topic Calculated Pivot Table from a different pivot table in QlikView

Calculated Pivot Table from a different pivot table

akashaj094 — Sat, 16 Nov 2024 00:24:27 GMT

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

Now I want a second pivot table like this

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!

Re: Calculated Pivot Table from a different pivot table

sergio0592 — Mon, 29 Jun 2020 11:21:07 GMT

Hi,

Try with

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

Re: Calculated Pivot Table from a different pivot table

akashaj094 — Mon, 29 Jun 2020 11:24:57 GMT

How will I link the two pivot tables?

Re: Calculated Pivot Table from a different pivot table

sergio0592 — Mon, 29 Jun 2020 11:49:32 GMT

Create a second pivot table and as expression write the formula

Re: Calculated Pivot Table from a different pivot table

akashaj094 — Mon, 29 Jun 2020 13:52:16 GMT

Thank You ! This worked