QlikSense Sum Error

[DoesitMatter]

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".

Thanks a 10**7!

Regards,

Alloy

[PV]

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

[pradosh_thakur]

Try 

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

or 

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

[Vamsi0529]

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