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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Chahine
Contributor
Contributor

Nested loop

Hi guys,  I want  to set up a Reference line Value in a graph in a manner that if  USP is  Greater than AVAL it takes the value of USP otherwise it returns AVAL Value here is my Expression: 

if ( Avg(Aggr(( if ([qtl_statistics.PARAM]='PRENDVIS',USP)), USP)) > Avg(Aggr((if([qtl_statistics.PARAM]='PRENDVIS',AVAL)), AVAL)),

Avg(Aggr((if([qtl_statistics.PARAM]='PRENDVIS',USP)), USP)),

(Avg(Aggr((if([qtl_statistics.PARAM]='PRENDVIS',AVAL)), AVAL))))

 

USP and AVAL Values are obtained after aggregation of  PARAM Column

Labels (2)
0 Replies