Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mvajhuddart
New Contributor

Using the TOTAL Qualifier with Dimension Limits

Hi all,

I am using the total qualifier in a measure to create a 100% stacked bar chart:

Sum(Revenue)

/

Sum(TOTAL<Week>Revenue)

This works perfectly until I add a limitation onto the "stacking" dimension (Fixed Number, Top 11 based on measure). After applying this, the numbers on the 100% Stacked version of my chart are completely different from those before adding the limitation. Has anyone experienced this before? Is there a fix?