topic Re: Max, sum aggregate in QlikView

Max, sum aggregate

Sun, 04 May 2014 22:53:07 GMT

Hi All,

I have a database with Area, Client No., Date & Value. A client can appear several times in the database.I would like to sum up all the Max(values) and display the data with Area as the dimension; effectively QlikView will be summing up the largest number at client level. I can't use the lastsortvalue because I have more than one transaction per day per client in some instances.

Thank you

Re: Max, sum aggregate

preminqlik — Mon, 05 May 2014 00:24:07 GMT

noconcatenate

FINAL:

Load Area,

clientNo,

Date,

max(value) as maxValue

resident orginal group by

Area,

clientNo,

Date;

drop table orginal;

>>in front end take Chart>dimension Area >> exp as sum(maxValue)

Re: Max, sum aggregate

anbu1984 — Mon, 05 May 2014 09:29:08 GMT

Select

Area,

ClientNo,

Sum(Max(Value))

From Table

Group by

Area,

ClientNo

Re: Max, sum aggregate

Mon, 05 May 2014 09:59:05 GMT

Thanks for the reply Prem,

I have decided to create a separate "value" mini table, as I don't want to drop the original table because the data as it was was perfect for other bits of analysis. Into the new table I pulled in distinct Client No and then Max(Value) grouped by ClientNo.

Many Thanks