topic Comparing two aggr values and showing only if it the condition is met in QlikView

Comparing two aggr values and showing only if it the condition is met

Wed, 25 Nov 2020 16:16:04 GMT

I need to compare two aggr values, to see if one group (ANTS) is greater sales than any of the other groups( BEES, FLIES, MICE)

Dimension:

Date

Group

Stores

Metric (Load if Group = ANTS sales are greater than ANY GROUP)

MIN(aggr(sum({<GROUP={'ANTS'} >}SALES),Date,Group,Stores)) > MIN(aggr(sum(SALES),DATE,Group,Stores)

I'm using a chart and I'm getting an empty chart.

Re: Comparing two aggr values and showing only if it the condition is met

ahaahaaha — Fri, 19 May 2017 07:42:06 GMT

Hi Rolando,

May be like this

=RangeMax(aggr(sum({<GROUP={'ANTS'} >}SALES),Date,Group,Stores),

aggr(sum({<GROUP={'BEES'} >}SALES),Date,Group,Stores),

aggr(sum({<GROUP={'FLIES'} >}SALES),Date,Group,Stores),

aggr(sum({<GROUP={'MICE'} >}SALES),Date,Group,Stores))

Regards,

Andrey

Re: Comparing two aggr values and showing only if it the condition is met

Fri, 19 May 2017 13:25:26 GMT

Andrey,

There is another dimension called Items and I need to compare the lowest priced item in group ANTS to see if its greater than any of the lowest priced item in the other group.

Thanks in advance,

Rolando