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
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
DoesitMatter
Contributor II
Contributor II

QlikSense Sum Error

Hi All,

 

I'm verifying a report and was shown that the total tickets sold is 89.

In a pivot table object created in QS, it appears that the summation is wrong.

Btw, the rest of the summation of other groups are correct.

Could anyone advise where could have possibly caused the "glitch".

QS Glitch.png

 

Thanks a 10**7!

 

Regards,

Alloy

Labels (1)
3 Replies
PV
Contributor II
Contributor II

Hi
If 89 is your expected result then, try changing Totals fucntion to 'Sum'.
pradosh_thakur
Master II
Master II

Try 

 

if (dimensionality()=0, sum(aggr(expression,dimesnion)),expression) 

 

or 

 

if (dimensionality()=0, sum(total Sales),Sum(Sales) 

Learning never stops.
Vamsi0529
Contributor
Contributor

Hi  Everyone,

My requirement I have Duration column like Below.

duration second's

00:00:28

00:00:28

00:00:28

00:00:29

00:00:29

00:00:29

 

When I Trying to sum i am getting 00:00:57

Can any one help me sum the above seconds