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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to Aggregate Total on Expression Straight Table?

     Hi please help me with the Aggregate Expression formula. New to QlikView thanks.

Aggregate.PNG

10 Replies
shansundar
Partner - Creator
Partner - Creator

Looks like there is an issue in your data model join which duplicates the invoiced quantity (4 times) and that's what summing up in the front end.

Is all fields in the straight table 1 (dimension & expression) are from same table in  data model or different ones.

Thanks,

Shan S