Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculation in pivot table

Hello,

I want to create a pivot table like this :

                         Week1     Week2     Week3

Stock                    10          30               40

Forecast                20          50               70

Production              40          60              80

Result                    30          40               50

Result = stock-forecast+Production

Stock of Week2 = Result of Week1, stock of Week3=Result of Week2, etc

Is this possible ?

1 Solution

Accepted Solutions
Not applicable
Author

Hi Diane,

You need to do some scripting to achieve the following.

Please find the attached qvw for reference.

Hope it helps.

Regards,

Jemimah

View solution in original post

1 Reply
Not applicable
Author

Hi Diane,

You need to do some scripting to achieve the following.

Please find the attached qvw for reference.

Hope it helps.

Regards,

Jemimah