Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akashaj094
Contributor II
Contributor II

Calculated Pivot Table from a different pivot table

Hi Everyone

Disclaimer: The data used in this post is dummy and not actual data.

I'm stuck at this thing that i'm working at. I have a pivot table in Qlikview with me. I want to make a second pivot table where the data needs to come from the first pivot table based on a calculation. Below is Table1

akashaj094_0-1593420725097.png

Now I want a second pivot table like this

akashaj094_1-1593420788767.png

In this pivot table the data has come from the first table like (2010,1) has data value = 34/96 from the first pivot table. All the other cells in the second pivot table are filled like this only (2010,2) = 23/34

Can someone tell me how to do this in Qlikview ? Any help will be greatly appreciated!

Labels (1)
2 Solutions

Accepted Solutions
sergio0592
Specialist III
Specialist III

Hi,

Try with

after(sum(value))/sum(value)

View solution in original post

sergio0592
Specialist III
Specialist III

Create a second pivot table and as expression write the formula

View solution in original post

4 Replies
sergio0592
Specialist III
Specialist III

Hi,

Try with

after(sum(value))/sum(value)

View solution in original post

akashaj094
Contributor II
Contributor II
Author

How will I link the two pivot tables?

sergio0592
Specialist III
Specialist III

Create a second pivot table and as expression write the formula

View solution in original post

akashaj094
Contributor II
Contributor II
Author

Thank You ! This worked