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: 
thewillemzelluf
Creator
Creator

total function

Hello everyone,

different charts.png

I have a question about the totals function. In the table (left in the image) the totals function is set to automatic. The sum of these amounts is 0.31653 ....

However, if I use the same calculation for the kpi graph, a different outcome will emerge. Any idea how I get the same result in both graphs?

The calculation used is:

=SUM(IF([Order registratiedatum] - Partijdatum > Gewenst, [Totaal geleverd], 0)) / SUM([Totaal geleverd])

Thanks in advance!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try a set expression that selects all possible values in your dimension field:

=SUM({<YourChartDimensionField = {"*"}>} IF([Order registratiedatum] - Partijdatum > Gewenst, [Totaal geleverd], 0))

/ SUM({<YourChartDimensionField = {"*"}>} [Totaal geleverd])

View solution in original post

4 Replies
swuehl
MVP
MVP

Does your dimension(s) in your chart show NULL in some of the records?

edit:

What if you make an active selection of all possible values in your dimension field? Do both charts show the same total now?

thewillemzelluf
Creator
Creator
Author

oh i see it, when i include null values i get the same value. any idea how to exclude null values in my KPI chart?

swuehl
MVP
MVP

Try a set expression that selects all possible values in your dimension field:

=SUM({<YourChartDimensionField = {"*"}>} IF([Order registratiedatum] - Partijdatum > Gewenst, [Totaal geleverd], 0))

/ SUM({<YourChartDimensionField = {"*"}>} [Totaal geleverd])

thewillemzelluf
Creator
Creator
Author

thankyou! it did work out!