Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jemelyah
New Contributor II

Strange pivot table behavior

Greetings to the community!

I struggle with the following Pivot table behavior:

Screenshot 101: Order Month-Project-Product, the TOTAL<Month> gives me the right values;

101.PNG

Screenshot 102: Order Product-Month-Project, the TOTAL<Month> gives the right values when all the levels are open,

102.PNG

however

Screenshot 103: same order, but when I close one of the drills (part. 'Door'), I get wrong total values.

103.PNG

What is wrong here - either it's me and a lack of understanding of Qlik features or is it a bug?

I've attached the the app with this table.

7 Replies
MVP
MVP

Re: Strange pivot table behavior

What is the total you are expecting to see? I am trying to understand that bit

Highlighted
jemelyah
New Contributor II

Re: Strange pivot table behavior

I want to get the 101 and 102 slide TOTAL <Month> disregarding the selections and drill-down states, like the ones I get in Screenshot 101 and 102, so basically it should show me the total costs per month in any of view combinations.

It would be the total cost of specific product per month.

MVP
MVP

Re: Strange pivot table behavior

May be this

If(Dimensionality() = 3, Aggr(nodistinct Sum(Cost), Month), Sum(TOTAL <Month> Cost))

jemelyah
New Contributor II

Re: Strange pivot table behavior

Nice! It works when the Month is at the level 3, however, when I move the month to the second level, it breaks. Maybe You know the trick?

MVP
MVP

Re: Strange pivot table behavior

Month is at the second level here, what's wrong?

Capture.PNG

alextimofeyev
Contributor II

Re: Strange pivot table behavior

Sunny,

Look at the value for "January" on the second level under "Door". It's 305, but it's supposed to be 420, just like the levels below.

MVP
MVP

Re: Strange pivot table behavior

I see what you mean..... now.... I will take a look at this and