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

Need help in aggregation of values

Hi I am new to Qlikview, I need some help on the issue I am stuck here. I tried to pull the sample data from the Excel sheet and when I tried to pull that data using the table view sales are not getting aggregated, please refer the below screen shot and give me some suggestions to proceed further on this. Thank you

2 Replies
Anonymous
Not applicable
Author

Hi,

From how you explained, the table view will only show what exactly is in the table.

To see an aggregate, try using a straight table graph with Item as a dimension and as a measure, you can have sum([R_POS Sales Actual])

rubenmarin1

Hi Harsha, Qlikview draws a row for each combination of dimension values. You use TOTAL to ignore (some) dimensions, ie:

sum(TOTAL <Item> [R_POS Sales Actual])