topic Re: Add current month and previous month data in QlikView

Add current month and previous month data

sunitha_chellaiah — Mon, 17 May 2021 13:54:30 GMT

Hi,

I want to add current month data with previous data in pivot table.

Please see the attached screenshot.

For month, I have taken monthnumber i.e. 1,2,3,etc.

I want output as , in monthnumber 2 , monthnumber 1 + monthnumber 2 values addition should come.

For example: For Ahmedabad, in monthnumber 2 value should come as 250 (126+124).

Experssion used : sum(NOS)

Kindly help me to solve this issue.

Thanks

mfchmielowski — Tue, 18 May 2021 07:18:33 GMT

Hi.

Do you want to add only one previous or every previous months?

Month2 =month1 +month2

Month3 =month1 +month2 +month3

Month4= month1 +month2 +month3+month4

Etc.?

sunitha_chellaiah — Tue, 18 May 2021 09:39:12 GMT

i want to add only one previous month.

Month2 =month1 +month2

Month3 =month2 +month3

etc.

mfchmielowski — Tue, 18 May 2021 09:48:42 GMT

Try then expression: sum(NOS) + if(before(sum(NOS))>0,before(sum(NOS)),0)