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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2009-05-22 08:37 PM

AGGR Function Problem

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/5460.AGGRExample.doc:550:0]I have a pivot table that show SUM(Qty) by YearQuarter and WeekInQtr and would like this data to show the cummulative by Week within th the Quarter

AGGR (NODISTINCT SUM(Qty), YearQuarter, WeekInQtr)

For some reason It will work fine for YearQuarter and also by WeekInQtr but will not work correctly for YearQuarter,WeekInQtr

I have attached a sample of the pivot - I want the total units to show cummulative by Week/Quarter down

Any help would be appreciated.

Thanks

Graham

260 Views
0 Likes
0 Replies