topic Re: aggregation in QlikView

aggregation

shayraber — Tue, 02 Dec 2014 14:54:09 GMT

hi,

i'm facing an issue while trying to do the following (i'll try to illustrate with an image attached).

i wan't to sum all data which is most recent (latest time-stamp for each value of my dimension) record per a dimension value

in my example the latest record time-stamp is: 02/12/2014 16:05 for all of the dimension values BUT that's NOT the case necessarily.

please assist me if you have a solution in mind,

thanks,

Shay

Re: aggregation

Tue, 02 Dec 2014 16:14:02 GMT

Please see attached.

I have created a Flag in the script which flags the max date across the host.

Re: aggregation

shayraber — Wed, 03 Dec 2014 07:51:36 GMT

Hi Zohaib,

Unfortunately, it does answer my question since I probably didn't explain myself good enough.

This is a hard coded solution while what I need is a dynamic one.

The set of data which I tried to demonstrate at the attached .xlsx file is only one out of hundreds of sets.

What I mean is that the data contains hundreds of record sets.

Since I can’t see any other solution I’ll create that table at the script while what I need is something that being calculated on the fly but due to the relatively low number of record sets it will be the fastest solution.

It’s not what I was looking for but it helps

Re: Re: aggregation

Wed, 03 Dec 2014 10:15:15 GMT

Hi Shay,

See attached, which will perform calculations on the fly.

Note by creating flags in the script the chart performance is much better. For what you are needing I have used the AGGR and RANK function.