Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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%
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.
I think it´s the way Dimension Limits works