topic Re: Variables with Different results in QlikView https://community.qlik.com/t5/QlikView/Variables-with-Different-results/m-p/1393333#M812985 <HTML><HEAD></HEAD><BODY><P>What is the expression you are using in your variable. Can you share a sample app to look into. May be in your table is it is calculating distinct values based on your dimensions. Can't answer until I see some sample data. Is it possible?</P></BODY></HTML> Fri, 22 Sep 2017 00:31:59 GMT vishsaggi 2017-09-22T00:31:59Z Variables with Different results https://community.qlik.com/t5/QlikView/Variables-with-Different-results/m-p/1393332#M812984 <HTML><HEAD></HEAD><BODY><P>HI, </P><P>I'm learning about variables and I am having some difficulties. </P><P></P><P>For Example: </P><P>I have a variable that is set up in my app called vGlobal_Ranking</P><P></P><P>If I use this variable in a KPI or a Gage&nbsp; I get Result 'X' (Which is the correct answer) </P><P>If I use this exact same variable in a table in the visualization, I get a completely different result (wrong result)</P><P></P><P>All 3 have the exact same measure, $(vGlobal_Ranking). </P><P></P><P>Why am I getting a different result in the table vs KPI or Gage?&nbsp; </P><P></P><P>The variables were causing errors in my reports and had to be eliminated completely, leading to very complicated formulas. </P><P>I think i'm missing something, knowledge-wise, when it comes to variables. I would appreciate if anyone could help me wrap my head around the subject and the reasons behind the different results. </P><P></P><P>Thanks</P><P></P><P>see below for a print screen of the diff, results, all 3 contained solely the same&nbsp; $(vGlobal_Ranking) variable </P><P><IMG alt="Global Ranking.png" class="jive-image image-1" src="/legacyfs/online/177389_Global Ranking.png" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Variables-with-Different-results/m-p/1393332#M812984 2020-11-25T16:16:04Z Re: Variables with Different results https://community.qlik.com/t5/QlikView/Variables-with-Different-results/m-p/1393333#M812985 <HTML><HEAD></HEAD><BODY><P>What is the expression you are using in your variable. Can you share a sample app to look into. May be in your table is it is calculating distinct values based on your dimensions. Can't answer until I see some sample data. Is it possible?</P></BODY></HTML> Fri, 22 Sep 2017 00:31:59 GMT https://community.qlik.com/t5/QlikView/Variables-with-Different-results/m-p/1393333#M812985 vishsaggi 2017-09-22T00:31:59Z Re: Variables with Different results https://community.qlik.com/t5/QlikView/Variables-with-Different-results/m-p/1393334#M812986 <HTML><HEAD></HEAD><BODY><P>The difference will be that the calculation within the table is in respect to the dimensions there and within the gauge or KPI it's without any dimension.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 22 Sep 2017 06:45:43 GMT https://community.qlik.com/t5/QlikView/Variables-with-Different-results/m-p/1393334#M812986 marcus_sommer 2017-09-22T06:45:43Z Re: Variables with Different results https://community.qlik.com/t5/QlikView/Variables-with-Different-results/m-p/1393335#M812987 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>When you are making the KPI and you are calling the variable it calculates the formula globally and doesn;t aggregate to anything unless you do it inside of it. </P><P></P><P>The expression you are calculating aggregates to dimension that you use in the table.</P><P></P><P>Hope it helped,</P><P>Andrei</P></BODY></HTML> Fri, 22 Sep 2017 06:56:43 GMT https://community.qlik.com/t5/QlikView/Variables-with-Different-results/m-p/1393335#M812987 andrei_delta 2017-09-22T06:56:43Z Re: Variables with Different results https://community.qlik.com/t5/QlikView/Variables-with-Different-results/m-p/1393336#M812988 <HTML><HEAD></HEAD><BODY><P>ok, thanks</P></BODY></HTML> Fri, 22 Sep 2017 09:04:46 GMT https://community.qlik.com/t5/QlikView/Variables-with-Different-results/m-p/1393336#M812988 Anonymous 2017-09-22T09:04:46Z