topic aggr function without selection in QlikView

aggr function without selection

Wed, 27 Oct 2010 15:38:29 GMT

Hi out there,

i got a problem where i can't find a solution for.

I tried to build a formula for a gauge chart with fixed min and max:


min(aggr(count(value), date))

This formula works perfect, if don't select a Day, Month or so. I want to get it fixed at the whole data (date's).
All my think's with {1} didn't worked out.

Maybe someone has an idea for me.

Thanks

Christoph

aggr function without selection

marcel_olmo — Wed, 27 Oct 2010 15:48:36 GMT

If you want it "static", which means if you select a day, month, etc..., you don't want the gauge chart to change. You have to put all the fields you don't want to change in a set analyisis like this example :

min(aggr( count({$<Year=,Month=,Day=>} [Asiento Importe]) ),date))

Hope it helps!!

aggr function without selection

johnw — Wed, 27 Oct 2010 20:52:04 GMT

I believe this:

min({1}aggr(count({1}value),date))

Both min() and count() need to be told that you want the whole data set, I believe.

aggr function without selection

Thu, 28 Oct 2010 08:55:15 GMT

Thanks,

this was the solution 😉