Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
john_duffy
Partner - Creator III
Partner - Creator III

Dimension Limits with Relative Expressions

Hello All.

We are in the process up upgrading from QV10 SR2 to QV11.2 SR3.

Some of our chart expressions stopped giving correct values when the applications were first opened in QV11.2.  The expressions were set to Relative and were displaying top N dimensions based on a ranking.  In QV10, I simply sorted the chart by ranking and set the Max Visible Number value on the chart's presentation tab.

I have attached a sample application to illustrate the issue and my fix.

The goal is to display the top 4 parts based on part ranking, not percentage.

Chart 1 - Displays all of the parts and percentages sorted correctly by Part Ranking.

Chart 2 - Displays the top 4 ranked parts, however, the values are not correct.  The values for parts C and E are no longer included in the calculation.  Therefore, all of the percentages are too high.

Chart 3 - Displays the top 4 ranked parts with the correct percentages.  In this chart, I unchecked Relative in the Expression tab and used Sum Total as a denominator in the expression to obtain the percentage.

The change I made in Chart 3 did resolve the issue.

I would like to know why the chart does not give the correct values in QV11.2 using Dimention Limits with Relative set for the expression.

Thanks,

John.

3 Replies
Clever_Anjos
Employee
Employee

Maybe because QlikView is first restricting to only 4 and then calculating the relative.

Please note that into Chart 2, the sum of % is 100%

john_duffy
Partner - Creator III
Partner - Creator III
Author

Thanks for the reponse.

That is what I am trying to find out - Why is QV11.2 calculating the percentages only based on the 4 parts.

Clever_Anjos
Employee
Employee

I think it´s the way Dimension Limits works