Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

Re:Next

hi,

PFA

my requiremnt is to get the minimum passes

and find the attched image for exact output.

Thank you

Suresh !

2 Replies
MK_QSL
MVP
MVP

SUM(Aggr(IF(If((sum(NUMERATOR)/sum(DENOMINATOR))>=PtileBeg and (sum(NUMERATOR)/sum(DENOMINATOR))<=PtileEnd,Star)=1,sum(DENOMINATOR) * $(vStar)-sum(NUMERATOR)),MEASURE_ID,Star))

Chanty4u
MVP
MVP
Author

hi Manish,

thanx for uaa replay am not getting the result

can u help me othe qvw and try t get the  output bro..

i tried like dis  am attchng the expression hope that exp wil helps you

Thank u

Suresh