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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate count of degree

Hello Everybody

How can i calculate count of degree for A,B,C?

Degree expression =>  if([Exclusive Percentage]<=.8,'A',if([Exclusive Percentage]<=.9,'B','C'))

      

StoreSalesAccumulated SalesInclusive PercentageExclusive PercentageDegree
1703 22,030,00022,030,0002.096%0.000%A
708 21,821,00043,851,0004.172%2.096%A
706 19,766,00063,617,0006.053%4.172%A
1912 14,876,00078,493,0007.468%6.053%A
1610 4,045,000837,245,00079.661%79.276%A
1510 4,005,000841,250,00080.042%79.661%A
1568 3,944,000845,194,00080.417%80.042%B
1220  3,920,000849,114,00080.790%80.417%B
1906  3,902,000853,016,00081.161%80.790%B
1561 3,747,000856,763,00081.518%81.161%B
1218 2,730,000949,728,00090.363%90.103%C
1402  2,695,000952,423,00090.619%90.363%C
1709  2,690,000955,113,00090.875%90.619%C
1934  2,682,000957,795,00091.130%90.875%C
1567  2,665,000960,460,00091.384%91.130%C
10 Replies
Not applicable
Author

Thanks.