topic Re: Retaining a value. in QlikView

Retaining a value.

Fri, 27 Dec 2013 06:40:27 GMT

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

Fri, 27 Dec 2013 06:48:43 GMT

Hi Karandeep,

Can you attach sample QVW file.

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

Fri, 27 Dec 2013 06:54:38 GMT

Hi Alok,

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

I am making a bar chart.

Thanks

Karan

Gysbert_Wassenaar — Fri, 27 Dec 2013 08:03:05 GMT

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

Fri, 27 Dec 2013 08:06:20 GMT

Thanks a lot Gysbert! It is working fine now.