topic Re: Calculating carry forwarded Month data in QlikView

Calculating carry forwarded Month data

nayanpatel — Thu, 08 May 2014 12:06:52 GMT

Hi Friends,

I have data as given below and i want to calculate carry forwarded sum as an example

For City London For April its 1 for May its 1 and For Jun its 1. Now I want to calculate

If I select Jun 14 then result will be for City London=6 i.e Arp 1 will go to Apr,May,Jun(3) then May's 1 will go to May,Jun(2)

and Jun's 1 will be for Jun only as this is for Jun selection.

If user will select Sep-14 then it will calculate as Apr's 1 will go for Apr, May,Jun,July,Aug,Sep, etc.

Thanks you

aaronnash — Thu, 08 May 2014 12:24:49 GMT

EDITED (had it backward):

Nayan,

I think you are looking for an expression that looks like this:

sum

({$ <Date={"<=$(=date(max(Date)))>=$(=addmonths(Min(Date)100))"} >} Entry)

nayanpatel — Thu, 08 May 2014 13:03:43 GMT

Hi Aaron Tanks for reply,

but its not like that

Its like

Apr May Jun

1 1 1

Then o/p as

Apr May Jun

1 1 1

1 1

JunTotal= 6