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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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....