Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the below expression (utilisation) evaluated under another expression having IF and AGGR statement on a PIVOT CHART. The expression for <50% is erroring out. What am i doing wrong, Any thoughts? Thanks!
Utilisation =Round(Max( {$<Date= {$(=Max(Date)'}>} {$<Metric = {"*off","*On"}>} [PEAK VALUE] /
Max({$<Date = {'$(=Max(Date))'}>} [CAPACITY])),.01)
Attached the <50% screenshot.
Have a look at the following Design Blog post, believe that may help you figure things out, there are some related posts too, just FYI.
https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822
Regards,
Brett