Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with sum

Dear all

I have a big problem and i have not idea how to solve it.

I have a pivot table with a sum function, I have selected only one record and sum is double of the value.

If I put field as dimension i can show that it's different,

Here's an example

PESCOUNTSUM(PES)
195013900


But if I put the expression without sum it returns correct value.

PESCOUNTPES
195011950


Problem is to solve that because it must be a sum. I'm doing only with one record to found error

Thanks for your help

1 Reply
Not applicable
Author

Probably you have a two records about that dimensions.......

....we need check you model....if you can......put here to check....