Qlik Community

New to Qlik Sense

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

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Creator III
Creator III

Sum total not equal to expected value

Hi All,

Looking at the below table, (Left) when i have the dimension Fibres my total is equal to 600 as expected.

(Right) When i remove the Fibres dimension and use set analysis, one of the values of 60 is not calculating giving me 60 short of the total expected. 

Sum( distinct {<SustainableLevel = {'Sustainable'}>}Weight)

Sum( distinct {<SustainableLevel = {'Not Sustainable'}>}Weight)

davyqliks_0-1648647927585.png

How can i get the total on the right table for the following:

Sum( distinct {<SustainableLevel = {'Sustainable'}>}Weight)

To include the other 60 to give me the 420.

 

I also tried an Aggr(Sum( distinct {<SustainableLevel = {'Sustainable'}>}Weight),Fibres) but i get a null return.

Thank you in advance.

 

Daniel

Labels (4)
12 Replies
davyqliks
Creator III
Creator III
Author

Really Appreciating your time Bruno,

but so sorry to say both of these have the same return as before.

Thank you

 

Daniel

davyqliks
Creator III
Creator III
Author

Hi,

There is one difference,

aggr(

sum( total Aggr(Sum( distinct {<SustainableLevel = {'Sustainable'}>}Weight),Fibres) )

, "Portal Order No." )

gives the total of the measure as 2448

while 

this

Sum(

aggr(

sum( total Aggr(Sum( distinct {<SustainableLevel = {'Sustainable'}>}Weight),Fibres) )

, "Portal Order No." )

 

totals the rows to 14668

 

Thank you Bruno. sorry this is not so simple to get the desired result.... you're still a legend for sharing your time and expert help.

thank you

 

Daniel

 

 

davyqliks
Creator III
Creator III
Author

Hi Bruno,

Did you have any other ideas on why the totals are not showing the values when selected individually?

davyqliks_0-1648738036981.png

 

Thank you

Daniel