topic Re: how it works? in QlikView https://community.qlik.com/t5/QlikView/how-it-works/m-p/695951#M1056258 <HTML><HEAD></HEAD><BODY><P>using sum(Sales) as expression and your dimension you get</P><P>the sum of all sales for 'Year 2010'</P><P>and the sum of all sales for 'Year 2011'</P><P></P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69688_1.png" style="width: auto; height: auto;" /></P></BODY></HTML> Sat, 25 Oct 2014 08:15:16 GMT maxgro 2014-10-25T08:15:16Z how it works? https://community.qlik.com/t5/QlikView/how-it-works/m-p/695950#M1056255 <HTML><HEAD></HEAD><BODY><P>dimension is =ValueList( 'Year 2011','Year 2010')&nbsp; and expression is sum(sales)&nbsp; </P><P></P><P>i feel this works like it will give separate&nbsp; sales for year 2010 and 2011? am i right?</P></BODY></HTML> Sat, 25 Oct 2014 06:22:29 GMT https://community.qlik.com/t5/QlikView/how-it-works/m-p/695950#M1056255 2014-10-25T06:22:29Z Re: how it works? https://community.qlik.com/t5/QlikView/how-it-works/m-p/695951#M1056258 <HTML><HEAD></HEAD><BODY><P>using sum(Sales) as expression and your dimension you get</P><P>the sum of all sales for 'Year 2010'</P><P>and the sum of all sales for 'Year 2011'</P><P></P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69688_1.png" style="width: auto; height: auto;" /></P></BODY></HTML> Sat, 25 Oct 2014 08:15:16 GMT https://community.qlik.com/t5/QlikView/how-it-works/m-p/695951#M1056258 maxgro 2014-10-25T08:15:16Z Re: how it works? https://community.qlik.com/t5/QlikView/how-it-works/m-p/695952#M1056260 <HTML><HEAD></HEAD><BODY><P>That expression will give the total of all Sales repeated for each value of the ValueList. Not very useful I imagine. </P><P></P><P>-Rob</P></BODY></HTML> Sat, 25 Oct 2014 08:55:03 GMT https://community.qlik.com/t5/QlikView/how-it-works/m-p/695952#M1056260 rwunderlich 2014-10-25T08:55:03Z