Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

emelke01
New Contributor

Rolling calculation in pivot table

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,

5 Replies

Re: Rolling calculation in pivot table

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
New Contributor

Re: Rolling calculation in pivot table

Hello Sunny T,

See an excel attached. hope it'll help

sujeetsingh
Honored Contributor III

Re: Rolling calculation in pivot table

Follow this thread for the hints.

rolling up totals in pivot table

karunpreet
Contributor

Re: Rolling calculation in pivot table

Hi

Did you get any solution for you problem

emelke01
New Contributor

Re: Rolling calculation in pivot table

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,

Community Browser