topic Re: Show Relative Expression per Dimension in QlikView

Show Relative Expression per Dimension

Anonymous — Tue, 23 Feb 2016 18:17:25 GMT

I have built the bar chart pictured below using two dimensions

- Month Name

- Pre

I have the relative box selected in the Expression dialogue to show the percentage of each Pre value.

This is not working how I want it to. I would want to see the percentage of each Pre value PER Month Name. Instead, it is giving me the percentage of all of the Pre values split up between month names.

I am sure this is an easy fix but I have not been able to resolve. Any help is appreciated.

Re: Show Relative Expression per Dimension

sunny_talwar — Tue, 23 Feb 2016 18:28:14 GMT

Instead of relative value use a calculation to calculate the percentage. Let's assume your expression is Sum(Sales), change it to:

Sum(Sales)/Sum(TOTAL <MonthYear> Sales)

Re: Show Relative Expression per Dimension

Anonymous — Tue, 23 Feb 2016 18:44:23 GMT

Ok Sunny. Used that as a work around to the relative box ... How do I get each specific percentage to display on the chart instead of a total percentage at the top?

Re: Show Relative Expression per Dimension

sunny_talwar — Tue, 23 Feb 2016 18:49:11 GMT

Go to presentation tab and select check this option