Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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