Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

aggr function without selection

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

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

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.

View solution in original post

3 Replies
marcel_olmo
Partner Ambassador
Partner Ambassador

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!!

johnw
Champion III
Champion III

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.

Not applicable
Author

Thanks,

this was the solution 😉