Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rajeshwar1
Partner - Contributor III
Partner - Contributor III

Count of Calculated Measure in front end in Qlik Sense

I have a cumulative percentage calculated measure in front end. 

 

I have wrote an expression:

if((num(rangesum(above(num(count({<[CB_tra_cur.DEBITMEMO_check]={'Y'},[CB_tra_cur.Final_Max_EXTERNALPAIDDATE0]={">=$(vPrev1ExtStartDate) <$(vPrev1monthExtEnddate)"}>}distinct CB_tra_cur.DEBITMEMO)),0,RowNo()))

 
/
 
 
sum(total aggr(count ({<[CB_tra_cur.DEBITMEMO_check]={'Y'},[CB_tra_cur.Final_Max_EXTERNALPAIDDATE0]={">=$(vPrev1ExtStartDate) <$(vPrev1monthExtEnddate)"}>}distinct CB_tra_cur.DEBITMEMO),[CB_tra_cur.Ageing Bucket_cre])),'#0%')
)>=0.92 ,'A','B')
 
 
 
now I want to count how many A and How many B are there .
 
Please Help
 
Labels (2)
0 Replies