topic Present month and previous month difference in QlikView https://community.qlik.com/t5/QlikView/Present-month-and-previous-month-difference/m-p/1439693#M514310 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I need difference on current cell as below</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177017_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Requirement is</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan-2012&nbsp; Feb-2012&nbsp; Mar-2012&nbsp; Apr-2012&nbsp;&nbsp; --- so on</P><P>Customer 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -800&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -320&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 110&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ---------so on</P><P>Customer 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 520&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -470&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -1090&nbsp;&nbsp;&nbsp;&nbsp; -------- so on</P><P></P><P>Meaning current month value - previous month value</P><P></P><P>I have attached test.qvw</P><P></P><P>I appreciate your suggestions</P><P>Thanks</P></BODY></HTML> Tue, 19 Sep 2017 08:12:29 GMT Anonymous 2017-09-19T08:12:29Z Present month and previous month difference https://community.qlik.com/t5/QlikView/Present-month-and-previous-month-difference/m-p/1439693#M514310 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I need difference on current cell as below</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177017_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Requirement is</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan-2012&nbsp; Feb-2012&nbsp; Mar-2012&nbsp; Apr-2012&nbsp;&nbsp; --- so on</P><P>Customer 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -800&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -320&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 110&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ---------so on</P><P>Customer 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 520&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -470&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -1090&nbsp;&nbsp;&nbsp;&nbsp; -------- so on</P><P></P><P>Meaning current month value - previous month value</P><P></P><P>I have attached test.qvw</P><P></P><P>I appreciate your suggestions</P><P>Thanks</P></BODY></HTML> Tue, 19 Sep 2017 08:12:29 GMT https://community.qlik.com/t5/QlikView/Present-month-and-previous-month-difference/m-p/1439693#M514310 Anonymous 2017-09-19T08:12:29Z Re: Present month and previous month difference https://community.qlik.com/t5/QlikView/Present-month-and-previous-month-difference/m-p/1439694#M514311 <HTML><HEAD></HEAD><BODY><P>Expression: <EM>=Alt(sum(InvoiceValue) - before(total sum(InvoiceValue)), 0)</EM></P><P>Turn off "Suppress Zero Values"</P><P></P><P>(tested on your model)</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177023_Capture.PNG" style="height: 88px; width: 620px;" /></P></BODY></HTML> Tue, 19 Sep 2017 08:19:52 GMT https://community.qlik.com/t5/QlikView/Present-month-and-previous-month-difference/m-p/1439694#M514311 jonathandienst 2017-09-19T08:19:52Z Re: Present month and previous month difference https://community.qlik.com/t5/QlikView/Present-month-and-previous-month-difference/m-p/1439695#M514312 <HTML><HEAD></HEAD><BODY><P>Hi Jonathan</P><P></P><P>It's works. I appreciate your help. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thanks</P></BODY></HTML> Tue, 19 Sep 2017 17:38:21 GMT https://community.qlik.com/t5/QlikView/Present-month-and-previous-month-difference/m-p/1439695#M514312 Anonymous 2017-09-19T17:38:21Z