topic Re: Strange pivot table behavior in App Development

Strange pivot table behavior

Anonymous — Fri, 07 Apr 2017 12:17:25 GMT

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;

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

however

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

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.

Re: Strange pivot table behavior

sunny_talwar — Fri, 07 Apr 2017 15:56:18 GMT

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

Re: Strange pivot table behavior

Anonymous — Mon, 10 Apr 2017 08:29:00 GMT

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.

Re: Strange pivot table behavior

sunny_talwar — Mon, 10 Apr 2017 10:08:31 GMT

May be this

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

Re: Strange pivot table behavior

Anonymous — Mon, 10 Apr 2017 14:21:46 GMT

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?

Re: Strange pivot table behavior

sunny_talwar — Mon, 10 Apr 2017 15:22:37 GMT

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

Re: Strange pivot table behavior

alextimofeyev — Mon, 10 Apr 2017 21:37:16 GMT

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.

Re: Strange pivot table behavior

sunny_talwar — Tue, 11 Apr 2017 01:26:04 GMT

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