Retaining a value.

[#1]

Hi,

Attached is a snapshot of a bar chart named BMI. Here the value of InQue Legend portrayed is the difference Received - Completed.

The problem is I have to retain the InQue value of previous months and use it in my expression for InQue value of subsequent months.

e.g. Jan -> Received = 3 and Completed = 0, so InQue = 3

Feb -> Received = 18 and Completed = 0, so InQue must be = 18 + 3(from previous month)

March -> Received = 239 and Completed = 243, so InQue = 239-243+(18+3) = 17 and so on..

How could I achieve this?

Appreciate your help.

Thanks

Karan

[#2]

Hi Karandeep,

Can you attach sample QVW file.

and how do you want this into Bar Chart or in Table chart ?

[#3]

Hi Alok,

Attached the file and made a minor correction in the post.

I am making a bar chart.

Thanks

Karan

[Gysbert_Wassenaar · Accepted solution]

Select the InQueue expression and set Accumulation for that expression to Full Accumulation.

[#5]

Thanks a lot Gysbert! It is working fine now.