Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

katwijck
New Contributor III

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

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:

QV Chart.PNG

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:

QV Chart Dimension.PNG

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

QV Expression.PNG

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

Thank you.

1 Solution

Accepted Solutions

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

Try this

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

2 Replies

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

Try this

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

katwijck
New Contributor III

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

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!