topic Re: Previous Year values calculation in Script in QlikView

Previous Year values calculation in Script

konidena — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have data here.

I need to make script in qlikview to find the Previous sales and my data should look like as below.

201501 19

201502 18

201503 25

Regards

Srinivas

sunny_talwar — Thu, 23 Jun 2016 12:45:12 GMT

May be this:

Table:

LOAD Date(MonthStart(Date#(MonthCode, 'YYYYMM')), 'YYYYMM') as MonthCode,

Sales

INLINE [

MonthCode, Sales

201601, 20

201602, 22

201603, 28

201501, 19

201502, 18

201503, 25

];

Left Join (Table)

LOAD AddYears(MonthCode, 1) as MonthCode,

Sales as PrevSales

Resident Table;