Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
katwijck
Contributor III
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
sunny_talwar

Try this

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

View solution in original post

2 Replies
sunny_talwar

Try this

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

katwijck
Contributor III
Contributor III
Author

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!