topic Re: How to combine sum & monthsstart in QlikView https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362869#M575138 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Above file is corrupted. Not sure if you can open it.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Thanks,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P></BODY></HTML> Wed, 23 May 2012 09:11:01 GMT IAMDV 2012-05-23T09:11:01Z How to combine sum & monthsstart https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362864#M575133 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm the beginner and need your help.</P><P>I would show in the one chart sales for current and previous months and don't know how to prepare script.</P><P>(Sum({$}[Sales 1])) - I used that one for present selected month.</P><P>What script should I use for presenting data tied with previous than selected month. I tried to use "MonthsStart(1,Period,-1)" but can not combine it with one above.</P><P></P><P>Regards,</P><P>Arek</P></BODY></HTML> Tue, 22 May 2012 09:31:03 GMT https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362864#M575133 2012-05-22T09:31:03Z Re: How to combine sum & monthsstart https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362865#M575134 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Arek,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">How about using Set Analysis to get the previous month sales numbers:</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">sum( {$&lt;MyMonth= {$(=Only(MyMonth)-1)}&gt;} Sales)</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">I'm attaching a simple Set Analysis tutorial for your reference.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Good luck.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P></BODY></HTML> Tue, 22 May 2012 09:47:19 GMT https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362865#M575134 IAMDV 2012-05-22T09:47:19Z Re: How to combine sum & monthsstart https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362866#M575135 <HTML><HEAD></HEAD><BODY><P>Deepak,</P><P>Thanks for your quick reply.</P><P>Using the code you already posted I get the same data (selected month) in both bars Actual &amp; Previous...</P><P>Regards,</P><P>Arek</P></BODY></HTML> Tue, 22 May 2012 10:16:51 GMT https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362866#M575135 2012-05-22T10:16:51Z Re: How to combine sum & monthsstart https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362867#M575136 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Arek - I should have been more specific. That was just an idea on how you can use the same in Set Analysis. Please can you post the same QVW file? I'm sure it's something to do with the date formats. I'll work with your example if you can provide...</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Cheers - DV</SPAN></P></BODY></HTML> Tue, 22 May 2012 10:21:18 GMT https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362867#M575136 IAMDV 2012-05-22T10:21:18Z Re: How to combine sum & monthsstart https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362868#M575137 <HTML><HEAD></HEAD><BODY></BODY></HTML> Wed, 23 May 2012 09:00:35 GMT https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362868#M575137 2012-05-23T09:00:35Z Re: How to combine sum & monthsstart https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362869#M575138 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Above file is corrupted. Not sure if you can open it.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Thanks,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P></BODY></HTML> Wed, 23 May 2012 09:11:01 GMT https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362869#M575138 IAMDV 2012-05-23T09:11:01Z Re: How to combine sum & monthsstart https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362870#M575139 <HTML><HEAD></HEAD><BODY><P>Could you open that one?</P><P></P><P>Regards,<BR />Arek</P></BODY></HTML> Wed, 23 May 2012 09:20:13 GMT https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362870#M575139 2012-05-23T09:20:13Z Re: How to combine sum & monthsstart https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362871#M575140 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Arek- Here you go. You will see previous month's data only when there is selection on Month Field. If you have multiple Year's data then you need to improve this expression to handle the January to December conversion for Previous Month.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">This is the expression :</SPAN></P><P></P><P><STRONG style="color: #000080; font-family: calibri,verdana,arial,sans-serif;">SUM({&lt;Month = {$(<EM style="color: #800000;">=Month(MakeDate(Year,Num(Month)-1)))</EM>}&gt;} Revenue)</STRONG></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">And I'm also attaching the QVW file for your reference.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">I hope this makes sense.<BR /></SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><A href="http://qlikshare.com/">www.QlikShare.com</A><BR /></SPAN></P></BODY></HTML> Wed, 23 May 2012 10:40:48 GMT https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362871#M575140 IAMDV 2012-05-23T10:40:48Z Re: How to combine sum & monthsstart https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362872#M575141 <HTML><HEAD></HEAD><BODY><P>Perfect solution:)</P><P>Thanks a lot</P></BODY></HTML> Wed, 23 May 2012 10:53:46 GMT https://community.qlik.com/t5/QlikView/How-to-combine-sum-monthsstart/m-p/362872#M575141 2012-05-23T10:53:46Z