topic Re: Set Analysis with Sum Function in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-Sum-Function/m-p/1291772#M403778 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG><SPAN style="color: #ff0000;">Above(</SPAN>Sum({&lt;Month = {'$(vLast)'}&gt;} Sale1)<SPAN style="color: #ff0000;">)</SPAN></STRONG></P></BODY></HTML> Tue, 22 Nov 2016 14:32:51 GMT sunny_talwar 2016-11-22T14:32:51Z Set Analysis with Sum Function https://community.qlik.com/t5/QlikView/Set-Analysis-with-Sum-Function/m-p/1291771#M403777 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to show sum of 2 fields for current selected month and the previous month, but for some reason I am not able to do so.</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144517_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>This is my data and I want when user selects a month It will show the sum of <STRONG>Sale1+Sale2</STRONG> along with the previous month in one row.</P><P>I managed to get the value of previous month using a variable, but when I use the formula its showing in two rows.</P><P></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/144518_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P>This is my formula. I am using a straight table.</P><P><IMG class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/144519_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Please help.</P></BODY></HTML> Tue, 22 Nov 2016 14:19:25 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Sum-Function/m-p/1291771#M403777 Anonymous 2016-11-22T14:19:25Z Re: Set Analysis with Sum Function https://community.qlik.com/t5/QlikView/Set-Analysis-with-Sum-Function/m-p/1291772#M403778 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG><SPAN style="color: #ff0000;">Above(</SPAN>Sum({&lt;Month = {'$(vLast)'}&gt;} Sale1)<SPAN style="color: #ff0000;">)</SPAN></STRONG></P></BODY></HTML> Tue, 22 Nov 2016 14:32:51 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Sum-Function/m-p/1291772#M403778 sunny_talwar 2016-11-22T14:32:51Z