Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Nikhil2725
Creator II
Creator II

Count IF

Hi All,

I have measure like:

Num(round(rangesum(above(total sum(GrossValue_LC),0,RowNo(total))))/
round(sum(total Aggr(sum(GrossValue_LC),PH6)))*100,'##.00')

Here I will get the Output in Percentage like(7.47%,14.49%,20.14%,80.56%,85.66%,87.99%)

Now my question is like I want count of percentage greater than 80.00% how can i Do it???..

Kindly Help Me...

 

22 Replies
Nikhil2725
Creator II
Creator II
Author

HI Sunny, in the below expression i need to filter from the billing year as well.

Billing year will be 2010,2011 and 2012.. This Billing year I have applied in the Filter...

Sum(Aggr(

If(Num(round(rangesum(above(total sum(GrossValue_LC),0,RowNo(total))))/
round(sum(total Aggr(sum(GrossValue_LC),PH6)))*100,'##.00') > 0.80, 1, 0)

, (Key, (=Sum(GrossValue_LC), desc))))

 

Load Script...

Data:
LOAD
PH6&'|'&PH6_desc&'|'&"Division" as Key
Resident Data_temp;

 

Nikhil2725
Creator II
Creator II
Author

Attached the Screenshot for the reference....

sunny_talwar

I don't really understand... are you able to share a sample where we can look at this?