topic How to sum also a different dimension value then listed Chart dimension values in QlikView

How to sum also a different dimension value then listed Chart dimension values

katwijck — Thu, 24 May 2018 11:02:05 GMT

Hi everyone,

I have been searching and trying suggestions from other discussions but I still have not the result I am looking for.

I have a Pivot Chart with 2 dimensions, Category (Category) and Month (Maand) which looks like this:

What I try to achieve is to calculate the percentage of each category being used against the total amount.

However I am not able to sum a not listed category in addition to the ones listed to be able to do this.

The Chart Category dimension is setup like this:

If I use the following expression, it gives per month dimension the total of the 3 listed Categories:

But how to get the "not listed" Category also in this ? (The not listed Category is "Overig (w.o. Mipo)"

Thank you.

sunny_talwar — Thu, 24 May 2018 11:04:52 GMT

Try this

Aggr(NODISTINCT Sum(CA_TruckFacts.Rides), Werkdag.Maandnaam)

katwijck — Thu, 24 May 2018 11:24:03 GMT

Hi Sunny,

Thanks for this, works like a charm!

Had to modify it like below to exclude the collected (instead of delivered) rows but with that added it does the trick:

Aggr(NODISTINCT Sum({<CA_TruckFacts.Trucknr={">0"}>}CA_TruckFacts.Rides), Werkdag.Maandnaam)

Have a good day!