Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
emelke01
Contributor
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
sunny_talwar

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

Hello Sunny T,

See an excel attached. hope it'll help

sujeetsingh
Master III
Master III

Follow this thread for the hints.

rolling up totals in pivot table

Anonymous
Not applicable

Hi

Did you get any solution for you problem

emelke01
Contributor
Contributor
Author

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,