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
Requirement:
Need to count number of EmpID's month wise for whom salary is greater then 75th fractile value .
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.
Kindly Help .
#QlikSense @sunny_talwar ,@Swuehl