Export data shows different sum than in app

[jasmina_karcic]

Hi experts,

When I export data from one application, and make sum of one column, it is different than sum in qlik sense app...

What is problem?

Thanks

Jasmina

[MK9885]

I don't think there should be a problem with your expression in Qlik.

the problem might be in FABS when you use that, negative symbol gets removed in Qlik and when you export, the number is taken as +

try using your expression by removing FABS and export the data, compare it with Qlik.

If you don't use FABS you'll see negative values in ()

[jasmina_karcic]

yes, definitely fabs() is problem in analytic...

[lfholland]

No, but you can add a column that concatenates A,B,C and D.  And then do the count on that column.

The formula to concatenate is =A2&B2&C2&D2 and then copy that down.