topic Help with expression in QlikView

Help with expression

qw_johan — Sat, 10 Dec 2011 17:39:06 GMT

I need some help with an expression.

The following works fine and gives me the day(my_date) when the number of people(id:s) are the most.

concat(aggr(if(rank(Count(DISTINCT ID),1,1)=1, MY_DATE), MY_DATE),',')

What I am looking to do is to pick the day(my_date) when the number of people(id:s) are the least.

Anybody know how to do it? I figure I can do it with rank but have been unsuccessful so far.

Thanks,

Johan

swuehl — Sat, 10 Dec 2011 19:07:15 GMT

try a negative expression in your rank function:

rank( -count(Distinct ID),1,1)

Hope this helps,

Stefan

qw_johan — Sat, 10 Dec 2011 20:19:52 GMT

Thanks for your quick reply.

I had no idea I could do a negative expression inside the rank function.