Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ranidas
Partner - Contributor III
Partner - Contributor III

Reg: Count values are coming incorrect in usage of fractile function in set expression qliksense

Hi Team , 
 
Need your help in below expression. 
 
This is a sample requirement to my actual requirement . 
 
I have a data as shown below :
emp Id , its domain ,subdomain salary details defined month wise
ranidas_0-1686927539951.png

 

Requirement:
Need to count number of EmpID's month wise for whom salary is greater then 75th fractile value .
ranidas_1-1686927676583.png

I am calculating 75th percentile value using fractile function using qliksense Month wise.

75th percentile :((Fractile( total <Month> Aggr( only(salary), Month, EmpId,salary) ,0.75 ) )

Count of EmpID which are greater then fractile value :
Count( {<salary= {">$(=Fractile( total <Month> Aggr( only(salary), Month, EmpId,salary) ,0.75 ))"}>}
distinct EmpId)

When selecting any particular month count is coming fine ,
but when selecting more then one month or no selection of month ,the inner fractile expression considering overall value and displaying incorrect results.It should also change when selected domain and subdomain.
ranidas_2-1686928097887.png

 

Kindly Help . 
 
#QlikSense  @sunny_talwar ,@ 

Labels (1)
0 Replies