Create a straight table chart with dimension PaySclTyp_Text (your Grade) and as expression:
=count(distinct if([Annual Sal_ANSALARY]>=F_Salary and [Annual Sal_ANSALARY]<=M_Salary, Employee_Code))
Just because I am curious:
What is a 44th Salary?
Count_2.qvw 2.2 MB
Maybe like attached?
I think your variables you defined won't take the dimension values into account, so I needed to calculate the percentiles inside the advanced aggregation like
if( [Annual Sal_ANSALARY] <= aggr( fractile(total<PaySclTyp_Text> [Annual Sal_ANSALARY] ,0.5 ), PaySclTyp_Text,Employee_Code)
and [Annual Sal_ANSALARY] >= aggr( fractile(total<PaySclTyp_Text> [Annual Sal_ANSALARY],0.44 ), PaySclTyp_Text,Employee_Code)
The provided solution was correct for 44th Count, Suppose I want same for 66th and 75th, For that what we need to change in expression. Can you help me on this.
For reference please attached qvw file.
Thanks & Regards,
This part of the expression is the upper bound, the median or 50th percentile:
fractile(total<PaySclTyp_Text> [Annual Sal_ANSALARY] ,0.50.)
and this second fractile function is the lower bound, the 44th percentile:
fractile(total<PaySclTyp_Text> [Annual Sal_ANSALARY] ,0.44 )
So just adapt those two numbers in bold as you need (take care of the upper and lower bound, if you e.g. use median and 66th percentage. Then you need to put 0.66 into the first fractile and 0.50 into the second. First value always larger equal than the second value).
Thanks for last solution.
Hi Can u help me on this ?
I want to send clipboard image by Outlook Box with any attachment. It should to go as an image in mail body. For this I am using the below macro. Please check it.
But my image is not going properly in mail body. I am able to send by attachment but not in mailbody.
Dim objOutlk 'Outlook
Dim objMail 'Email item
Const olMailItem = 0
Const CdoReferenceTypeName = 1
Set objOutlk = CreateObject("Outlook.Application")
Set objMail = objOutlk.createitem(olMailItem)
Set Rng = Nothing
objMail.To = "email@example.com"
objMail.subject = "OMS DASHBOARD"
ActiveDocument.Sheets("Dashboard-email").ExportBitmapToFile "\\172.16.11.211\Documents\OMS DASHBOARD.jpeg"
strMsg = "This is an automatic generated email from QlikView for OMS DASHBOARD."
objMail.body = strMsg
objMail.HTMLBODY = "<HTML><BODY><img align=baseline border=0 hspace=0 src='cid:\\172.16.11.211\Documents\test.jpeg'</BODY></HTML>"
Set objMail = Nothing
Set objOutlk = Nothing
Msgbox " Mail delivered"