Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Champion III
Champion III

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
Highlighted
MVP
MVP

Re:Next

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))

Highlighted
Champion III
Champion III

Re:Next

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