topic Re: Rolling calculation in pivot table in QlikView

Rolling calculation in pivot table

emelke01 — Wed, 08 Jun 2016 07:37:41 GMT

Hello fellows.

Firstly sorry if something has already been asked and answered - I couldn't find.. Shall be glad if someone gives a link.

What my problem is:

I have -

1. a number of materials

2. consumption figures for them in future

3. delivery figures for them in future

4. current stock for these materials

What I need: In pivot table to have a line where I could see calculated future stock. - there I'll see when it goes below zero.

In excel it's done easily:

1. For first week = current stock - consumption + delivery

2. For every next week = previous week calculated stock - consumption + delivery (relative formulas)

Hope in Qlikview that can be done also.

To demonstrate what I need I attach a screenshot with a simple example created in excel. Hope it'll help.

Thanks in advance,

sunny_talwar — Wed, 08 Jun 2016 09:40:10 GMT

Would you be able to share the raw data behind the chart you are looking for? It would be easier to help if you can provide a qvw or an Excel

emelke01 — Wed, 08 Jun 2016 11:05:46 GMT

Hello Sunny T,

See an excel attached. hope it'll help

sujeetsingh — Wed, 08 Jun 2016 11:24:09 GMT

Follow this thread for the hints.

Anonymous — Tue, 30 Aug 2016 13:28:12 GMT

Did you get any solution for you problem

emelke01 — Thu, 16 Feb 2017 09:46:41 GMT

Hello. Sorry for a long silence..

No, I have not got a sollution. Now it became again necessary.

I'd appreciate any help from gurus

To make that more clear I made an example in QV and in excel with the same data - what I need (marked with yellow).

Thanks in advance,