Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
anuragsapanbhar
Creator
Creator

Different calculations for different views in a pivot table

Hi,

I am wondering if its possible to show different calculations for different view in a pivot table.

To make myself clear, I have the below table where I have Region, Country, Entity & Value.

 

RegionCountryBookingEntiryValue
R1C1B14
R1C1B25
R1C1NA10

The NA in Booking entity is the country level data, where as rest (B1, B2) entity level data.

What I am trying to do, that when showing in a pivot table if I expand the country it should show B1, B2, NA. Its easy and it can be done.

But if I collapse the county node, it only should show the value for NA, rather than summing up B1+B2+NA, like its showing below, which I don't want.

Ideally it should be showing 10, not 19.

Please help.

stalwar1‌ any help buddy?

1 Solution

Accepted Solutions
andrey_krylov
Specialist
Specialist

Hi, Anurag. Dimetionality() will help you. See attached

View solution in original post

1 Reply
andrey_krylov
Specialist
Specialist

Hi, Anurag. Dimetionality() will help you. See attached