topic Aggregate dimension in QlikView

Aggregate dimension

Tue, 24 Nov 2015 02:15:38 GMT

Hi all,

I'm trying to get the total of the dimension(Peer) to show in the chart no matter what value in the second dimension has been selected.

In this example I want to have the total shown for the Ref1 dimension shown as the Peer Performance no matter what Ref2 is selected.

If I select a single Ref2 (as show above here) value then I want the total of 107 to show in the Peer Performance measure, no matter what Ref2 I have selected. Ref1 is the parent, which can have 1 or many Ref2 values.

I have used a number of different Sum(Aggr) or Aggr(Sum)...total etc.... variations but nothing seems to be working.

Any ideas would be greatly appreciated.

Many thanks.

Re: Aggregate dimension

Mark_Little — Wed, 25 Nov 2015 09:34:58 GMT

Hi,

Could you share a sample QVW?

I would be Looking at something like

AGGR(SUM({1}Value),PEER)

Mark

Re: Aggregate dimension

PrashantSangle — Wed, 25 Nov 2015 09:47:46 GMT

Hi,

dont required any aggr()

just try with

sum({1}Value)

Regards

Re: Aggregate dimension

Gysbert_Wassenaar — Wed, 25 Nov 2015 09:51:45 GMT

Try Sum({<Ref2=>} TOTAL <Ref1> Peer)

Or Sum({<Ref2=>} TOTAL <Ref1> Days) if you want to see 107 as a result.