topic Re: Why does MIN value from an AGGR expression return a 0 but MAX and AVG work? See example in QlikView

Why does MIN value from an AGGR expression return a 0 but MAX and AVG work? See example

jblomqvist — Wed, 28 Oct 2015 17:29:26 GMT

Hi all,

In the example below I get a 0 when I try to get the Min value from an AGGR expression. Max and Avg work so I don't understand why Min doesn't work.

My expressions are:

Max: =Num(Max(Aggr(Sum(LineSalesAmount), SalesPerson)), '#,##0')

Min: =Num(Min(Aggr(Sum(LineSalesAmount), SalesPerson)), '#,##0')

Any ideas please?

hic — Wed, 28 Oct 2015 17:37:29 GMT

You probably have "Suppress Zero-values" checked in the straight table, which hides a salesperson with 0 as sales amount.

HIC

m_woolf — Wed, 28 Oct 2015 17:38:44 GMT

Here's a guess:

your straight table has suppress zero values checked.