topic Get dimension value in expression in QlikView https://community.qlik.com/t5/QlikView/Get-dimension-value-in-expression/m-p/535288#M199990 <HTML><HEAD></HEAD><BODY><P>Is there any way to get dimension value inside expression using set anaysis?</P><P></P><P>I need to get average sum of previous values not using function above.</P><P>Amount of "steps" for average sum calculations is set by slider value.</P><P>Also, if I select some values if field "Num" it should calculates correctly.</P><P></P><P>There is only one problem, it calculates correctly only for the maximum value in field "Num".</P><P>For all previous values resulting value is incorrect.</P><P></P><P>Please advice how to correct formula to let it calculate correctly fot all other "Num" values?</P><P>It works now only for one <EM>max</EM> value...</P><P></P><P>There is .qvw file with all calculations and formulas.</P><P>Please see some screenshots of chart with correct/incorrect values.</P><P><IMG alt="for_community.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/50081_for_community.png" style="width: 620px; height: 430px;" /></P><P></P><P><IMG alt="for_community2.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/50082_for_community2.png" style="width: 620px; height: 139px;" /></P><P></P><P>Thanks in advance!</P></BODY></HTML> Thu, 05 Dec 2013 19:27:52 GMT 2013-12-05T19:27:52Z Get dimension value in expression https://community.qlik.com/t5/QlikView/Get-dimension-value-in-expression/m-p/535288#M199990 <HTML><HEAD></HEAD><BODY><P>Is there any way to get dimension value inside expression using set anaysis?</P><P></P><P>I need to get average sum of previous values not using function above.</P><P>Amount of "steps" for average sum calculations is set by slider value.</P><P>Also, if I select some values if field "Num" it should calculates correctly.</P><P></P><P>There is only one problem, it calculates correctly only for the maximum value in field "Num".</P><P>For all previous values resulting value is incorrect.</P><P></P><P>Please advice how to correct formula to let it calculate correctly fot all other "Num" values?</P><P>It works now only for one <EM>max</EM> value...</P><P></P><P>There is .qvw file with all calculations and formulas.</P><P>Please see some screenshots of chart with correct/incorrect values.</P><P><IMG alt="for_community.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/50081_for_community.png" style="width: 620px; height: 430px;" /></P><P></P><P><IMG alt="for_community2.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/50082_for_community2.png" style="width: 620px; height: 139px;" /></P><P></P><P>Thanks in advance!</P></BODY></HTML> Thu, 05 Dec 2013 19:27:52 GMT https://community.qlik.com/t5/QlikView/Get-dimension-value-in-expression/m-p/535288#M199990 2013-12-05T19:27:52Z