Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

Expression error on using another Expression inside IF / AGGR Statement

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.

1 Reply
Highlighted
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.

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett

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.