topic Re: Values from another column / previous month in QlikView

Values from another column / previous month

prma7799 — Tue, 25 Apr 2017 06:10:11 GMT

Dear All,

I have one report in that i have 4 columns

[OPENING STK] ,

[TOTAL RECEIPT] ,

[TOTAL ISSUE] ,

[CL STK AFTER EXP ]

[CL STK AFTER EXP ] = [OPENING STK] + [TOTAL RECEIPT] - [TOTAL ISSUE]

In our Database the [OPENING STK] manually entered 0 for the period of [APR 2012-13].

APR....

When I select May

Now my requirement is whenever user select May 2012-13 to till date [OPENING STK] will be the last month of

[CL STK AFTER EXP ]

Expected Output for May and so on month years

I really appreciate your help.

Please find the sample attachment for Apr data and expected out put for May

Thanks..

tresB — Tue, 25 Apr 2017 06:59:40 GMT

QVW not opening. If section access is there in the app, remove it and then share once again.

nagarjuna_kotha — Tue, 25 Apr 2017 07:24:29 GMT

PFA....

prma7799 — Tue, 25 Apr 2017 11:12:23 GMT

Please find the updated file.

Thanks

nagarjuna_kotha — Wed, 26 Apr 2017 05:40:57 GMT

As per your logiv chck this