Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

qw_johan
Contributor

Help with expression

Hi

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

1 Solution

Accepted Solutions
MVP
MVP

Help with expression

try a negative expression in your rank function:

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

Hope this helps,

Stefan

2 Replies
MVP
MVP

Help with expression

try a negative expression in your rank function:

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

Hope this helps,

Stefan

qw_johan
Contributor

Help with expression

Thanks for your quick reply.

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