topic Re: aggregate in QlikView

aggregate

neha_sri — Tue, 02 Dec 2014 12:41:00 GMT

Hi,

I have data at Dyn Pump param id and I wantit to sum on Zone level ,

I have used following expression

aggr(sum( if([%Link Pump Group]<>[DYN Pump Group Id] ,

if( [Pump ID]=[DYN Pump Id] ,

if( IsNull([DYN Pump Param Id])=0,Volume)))),[DYN Pump Param Id],[DYN Pump Param Id],[Zone Name])

My data is repeating,

For Zone Central the answer should be 35572.33.

Please correcty my expression

Thanks

Re: aggregate

Tue, 02 Dec 2014 12:47:20 GMT

Try

SUM(TOTAL <Zone Level> Volume)

Re: aggregate

its_anandrjs — Tue, 02 Dec 2014 12:48:45 GMT

Write like

aggr(sum( if([%Link Pump Group]<>[DYN Pump Group Id] ,
if( [Pump ID]=[DYN Pump Id] ,
if( IsNull([DYN Pump Param Id])=0,Volume)))),[DYN Pump Id],[DYN Pump Param Id],[Zone Name])

aggr(sum( Total if([%Link Pump Group]<>[DYN Pump Group Id] ,
if( [Pump ID]=[DYN Pump Id] ,
if( IsNull([DYN Pump Param Id])=0,Volume)))),[DYN Pump Id],[DYN Pump Param Id],[Zone Name])

Regards

Anand