Andrew_Incite
Partner - Contributor II
‎2019-03-20
11:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Need to display Max across dimension for every dimension value
I have a requirement to show % of Max in a drill down capacity. Where the max over a brand is calculated for a sub group, and displayed alongside the values for each brand, something like this...
In this particular scenario, Brand 1 is always the max, and is wired in the back end to be such.
I have tried different variants of Max(Aggr(sum)))...etc with no success.
427 Views
1 Solution
Accepted Solutions
Vegar
MVP
‎2019-03-20
11:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You should look into the total argument inside your AVG() or SUM() aggregations.
This Qlik help page might be a good read for you: https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Examples%20o...
This Qlik help page might be a good read for you: https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Examples%20o...
Vegar
Qlik Community MVP
Qlik Community MVP
422 Views
2 Replies
Vegar
MVP
‎2019-03-20
11:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You should look into the total argument inside your AVG() or SUM() aggregations.
This Qlik help page might be a good read for you: https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Examples%20o...
This Qlik help page might be a good read for you: https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Examples%20o...
Vegar
Qlik Community MVP
Qlik Community MVP
423 Views
Andrew_Incite
Partner - Contributor II
‎2019-03-20
03:15 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I see, the solution was to use TOTAL with multiple qualifying fields.
I am building a self service report though and I wonder if there is a way to have it dynamically respond to the level of detail needed.
Thank you!
406 Views