New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:
Contributor III

total function

Hello everyone,

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])

1 Solution

Accepted Solutions
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])

4 Replies
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?

Contributor III
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?

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])

Contributor III
Author

thankyou! it did work out!

Tags
Community Browser