Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qw_johan
Creator
Creator

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
swuehl
MVP
MVP

try a negative expression in your rank function:

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

Hope this helps,

Stefan

View solution in original post

2 Replies
swuehl
MVP
MVP

try a negative expression in your rank function:

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

Hope this helps,

Stefan

qw_johan
Creator
Creator
Author

Thanks for your quick reply.

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