topic Re: Dimension Limits with Relative Expressions in QlikView https://community.qlik.com/t5/QlikView/Dimension-Limits-with-Relative-Expressions/m-p/557799#M208233 <HTML><HEAD></HEAD><BODY><P>Maybe because QlikView is first restricting to only 4 and then calculating the relative.</P><P>Please note that into Chart 2, the sum of % is 100%</P></BODY></HTML> Thu, 31 Oct 2013 18:06:44 GMT Clever_Anjos 2013-10-31T18:06:44Z Dimension Limits with Relative Expressions https://community.qlik.com/t5/QlikView/Dimension-Limits-with-Relative-Expressions/m-p/557798#M208232 <HTML><HEAD></HEAD><BODY><P>Hello All.</P><P></P><P>We are in the process up upgrading from QV10 SR2 to QV11.2 SR3.</P><P></P><P>Some of our chart expressions stopped giving correct values when the applications were first opened in QV11.2.&nbsp; The expressions were set to Relative and were displaying top N dimensions based on a ranking.&nbsp; In QV10, I simply sorted the chart by ranking and set the Max Visible Number value on the chart's presentation tab.</P><P></P><P>I have attached a sample application to illustrate the issue and my fix.</P><P></P><P>The goal is to display the top 4 parts based on part ranking, not percentage.</P><P></P><P>Chart 1 - Displays all of the parts and percentages sorted correctly by Part Ranking.</P><P>Chart 2 - Displays the top 4 ranked parts, however, the values are not correct.&nbsp; The values for parts C and E are no longer included in the calculation.&nbsp; Therefore, all of the percentages are too high.</P><P>Chart 3 - Displays the top 4 ranked parts with the correct percentages.&nbsp; In this chart, I unchecked Relative in the Expression tab and used Sum Total as a denominator in the expression to obtain the percentage.</P><P></P><P>The change I made in Chart 3 did resolve the issue.</P><P></P><P>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.</P><P></P><P>Thanks,</P><P>John.</P></BODY></HTML> Thu, 31 Oct 2013 17:55:31 GMT https://community.qlik.com/t5/QlikView/Dimension-Limits-with-Relative-Expressions/m-p/557798#M208232 john_duffy 2013-10-31T17:55:31Z Re: Dimension Limits with Relative Expressions https://community.qlik.com/t5/QlikView/Dimension-Limits-with-Relative-Expressions/m-p/557799#M208233 <HTML><HEAD></HEAD><BODY><P>Maybe because QlikView is first restricting to only 4 and then calculating the relative.</P><P>Please note that into Chart 2, the sum of % is 100%</P></BODY></HTML> Thu, 31 Oct 2013 18:06:44 GMT https://community.qlik.com/t5/QlikView/Dimension-Limits-with-Relative-Expressions/m-p/557799#M208233 Clever_Anjos 2013-10-31T18:06:44Z Re: Dimension Limits with Relative Expressions https://community.qlik.com/t5/QlikView/Dimension-Limits-with-Relative-Expressions/m-p/557800#M208234 <HTML><HEAD></HEAD><BODY><P>Thanks for the reponse.</P><P></P><P>That is what I am trying to find out - Why is QV11.2 calculating the percentages only based on the 4 parts.</P></BODY></HTML> Thu, 31 Oct 2013 18:11:41 GMT https://community.qlik.com/t5/QlikView/Dimension-Limits-with-Relative-Expressions/m-p/557800#M208234 john_duffy 2013-10-31T18:11:41Z Re: Dimension Limits with Relative Expressions https://community.qlik.com/t5/QlikView/Dimension-Limits-with-Relative-Expressions/m-p/557801#M208235 <HTML><HEAD></HEAD><BODY><P>I think it´s the way Dimension Limits works</P></BODY></HTML> Thu, 31 Oct 2013 18:39:18 GMT https://community.qlik.com/t5/QlikView/Dimension-Limits-with-Relative-Expressions/m-p/557801#M208235 Clever_Anjos 2013-10-31T18:39:18Z