Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Expression error on using another Expression inside IF / AGGR Statement


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.

1 Reply
Digital Support
Digital Support

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.



To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.