Show Aggr values, without the Aggr Dimension

skyCoin — Thu, 07 Jun 2018 14:21:56 GMT

Hello All,

Say I have two fields Type and SubType, and a metric Sales Dollars.

I want to see the max Sales Dollars per each Type, but populated in a table with just SubType as a dimension.

Type Sales

A 10

B 20

C 30

Type SubType Sales

A A1 10

B B1 10

B B2 10

C C1 10

C C2 10

C C3 10

This is the result I want:

SubType Sales

A1 10

B1 20

B2 20

C1 30

C2 30

C3 30

Note that each SubType is unique to a single Type. I get the results I want with Type added as another dimension, but I require that the expression work only with SubType.

No hidden dimensions please.

Here is the aggr expression that I have attempted. I feel like this is possible to do?

sum( Aggr( Sum(Sales), Type))

Re: Show Aggr values, without the Aggr Dimension

sunny_talwar — Thu, 07 Jun 2018 15:37:13 GMT

May be this

Sum(Aggr(NODISTINCT Sum(Sales), Type))

Re: Show Aggr values, without the Aggr Dimension

sunny_talwar — Thu, 07 Jun 2018 15:37:52 GMT

Or this

Aggr(Sum(TOTAL <Type> Sales), Type, SubType)

topic Re: Show Aggr values, without the Aggr Dimension in QlikView

Show Aggr values, without the Aggr Dimension

Re: Show Aggr values, without the Aggr Dimension

Re: Show Aggr values, without the Aggr Dimension