Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Help: How to create table with aggregated values?

Hi All,

I am trying to create a secondary table from my primary table to include aggregated values per dimension. For the example given below where I have a daily record of 'Item Total' I would like to create a table which sums it up by month. I would also like to add a column which gives the max and min date for each store. To put it in context, the difference between the max and min date gives me how long the store has been open for. Please note that I have only added records for only 5 days.

Is it possible to do this on the load script in QlikView? If so, what are the functions/load syntax that I can use to aggregate by store id and month and do the monthly sum?

   

Store IDItem TotalCOB DateSnapshot
X1001/01/2018Jan
X1002/01/2018Jan
X1003/01/2018Jan
X1004/01/2018Jan
X1005/01/2018Jan
X501/02/2018Feb
X502/02/2018Feb
X503/02/2018Feb
X504/02/2018Feb
X505/02/2018Feb
Y701/01/2018Jan
Y702/01/2018Jan
Y703/01/2018Jan
Y704/01/2018Jan
Y705/01/2018Jan
Y601/02/2018Feb
Y602/02/2018Feb
Y603/02/2018Feb
Y604/02/2018

Feb

Aggregated table I want to achieve:

   

Store IDItem TotalSnapshotMin DateMax Date
X50Jan01/01/201805/02/2018
X25Feb01/01/201805/02/2018
Y35Jan01/01/201805/02/2018
Y24Feb01/01/201805/02/2018

Many thanks,

Raj

1 Reply
Highlighted