Previous Month Sales in Script

Wed, 28 Jun 2017 17:09:36 GMT

Hi All,

I have an requirement to add Previous Month Sales in the Total Sales . Total Sales is Last Plan Sales +Previous Month Actual Sales . I was calculating all of this in Qlikview Script. In my table two dates field are present such as Calendar Year ,Calendar-YearMonth having Value Like 201701,201702,201703 and so on. So, I want to find out previous month Sales so I can add it and calculate Total Sales .

Please provide me any Idea to achieve this . Thanks in advance !!

Regards

Deepak

Re: Previous Month Sales in Script

aarkay29 — Wed, 28 Jun 2017 18:01:47 GMT

something like this

Load *,

if(Isnull(peek(Sales)),0,peek(Sales))+Sales as TotalSales;

Load * Inline [

Calendar-YearMonth,Sales

201701,250

201702,350

201703,450

201704,550

];

topic Previous Month Sales in Script in QlikView

Previous Month Sales in Script

Re: Previous Month Sales in Script