Need Help (Previous month tickets add in current month)

[gireesh1216]

Hello Team,

I have  data like this:

LOAD * Inline [

Date,LOB,Pending

Jan2018,A,10

Jan2018,B,14

Jan2018,C,5

Jan2018,D,6

Feb2018,A,11

Feb2018,B,7

Feb2018,C,4

Feb2018,D,9

Mar2018,A,12

Mar2018,B,7

Mar2018,C,4

Mar2018,D,9

];

Calculation:

In Jan2018 A LOB Pending Tickets is 10

In Feb2018 A LOB Pending Tickets Is 10+11=21(Jan2018 Pending+Feb2018 Pending)

In Mar2018 A LOB Pending Tickets is 10+11+12=33(Jan2018 pending+Feb2018 Pending+Mar2018 Pending)

........Same for other LOB as well....

How to achieve this in qlikivew?

Expected Results:

[Gopi_E]

Hi Gireesh,

Dimensions are Date in X-Axis and LOB as a Y-Axis

Just put expression as Sum(Pending)

then you should select Accumulate option under Expression tab -> Accumulation

I think this is you are expecting

Regards,

Gopi

[jyothish8807]

Hi Gireesh,

If you do not want to use the "Accumulte" option , then you can try this expression as well.

rangesum(above(Sum(Pending),0,rowno()))

Br,

KC