topic Re: data aggregation while loading data in QlikView

data aggregation while loading data

Anonymous — Tue, 19 May 2015 10:19:09 GMT

Hi,

I'd like to aggregate the data while loading it from the Source.

Let me give you an example.

This is my data. There are fields 'year' and 'month'. But actually I don't need split by month in my dashboard. So I'd like to aggregate the data by year and make the whole dataset smaller. Is it possible on the backfront in QlikView? !

Brands	Year	Month	Cost
Brand1	2013	Jan	10
Brand2	2013	Feb	15
Brand1	2013	Mar	20
Brand1	2013	Apr	30
Brand2	2013	May	10
Brand1	2014	Jan	5
Brand2	2014	Feb	15
Brand1	2014	Mar	20
Brand2	2014	Apr	30
Brand1	2014	May	10

Thank you in advance,

Larisa

Re: data aggregation while loading data

sunny_talwar — Tue, 19 May 2015 10:57:42 GMT

Is this what you are envisioning?

Script:

Table:

LOAD Brands,

Year,

Month,

Cost

FROM

[https://community.qlik.com/thread/164550]

(html, codepage is 1252, embedded labels, table is @1);

Table1:

LOAD Brands,

Year,

Sum(Cost) as Cost

Resident Table

Group By Year, Brands;

DROP Table Table;

If yes then PFA..

Best,

Sunny

Re: data aggregation while loading data

awhitfield — Tue, 19 May 2015 11:23:30 GMT

Or just don't load the Month data.

Andy

Re: data aggregation while loading data

Agis-Kalogiannis — Tue, 19 May 2015 11:25:49 GMT

The Group By clause is what you need to do something like this on the script.

If you need something similar on the front end, you'll have to use the aggr() function.

example:

aggr(sum(Cost), Year) or aggr(sum(Cost), Year, Brands) depending on what you want to show.

Agis

Re: data aggregation while loading data

Anonymous — Wed, 20 May 2015 13:00:21 GMT

Thanks everyone for your comments!