Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

dmelillo
Contributor II

Show Relative Expression per Dimension

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.

Capture.JPG

1 Solution

Accepted Solutions

Re: Show Relative Expression per Dimension

Go to presentation tab and select check this option

Capture.PNG

3 Replies

Re: Show Relative Expression per Dimension

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)

dmelillo
Contributor II

Re: Show Relative Expression per Dimension

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?

Capture2.JPG

Re: Show Relative Expression per Dimension

Go to presentation tab and select check this option

Capture.PNG

Community Browser