topic Re: Sort expression with Rank in QlikView

Sort expression with Rank

dana — Sat, 16 Nov 2024 17:52:44 GMT

Hi,

My table displays deviations in ascending order.

I have a calculated DateTime dimension for the top 30.

I use the following sort expression on the DateTime dimension based on rank:

When the rank is equal, I would like the dates to be in ascending order.

Any ideas how it can be done?

Thanks in advance!

chrismarlow — Wed, 04 Nov 2020 15:59:45 GMT

Hi,

Can you add a secondary Rank with suitable divisor to split the rank out, something like;

Cheers,

Chris.

dana — Wed, 04 Nov 2020 17:50:52 GMT

Great idea! Thanks!

I needed to modify the timestamp to a number in order for it to work:

Year(DateTime) & Num(Month(DateTime),'00') & Num(Day(DateTime),'00')&Num(Hour(DateTime),'00')&Num(Minute(DateTime),'00') as DateTimeNum

And the sort expression is:

Rank(Sum(Value)) + (Rank(DateTimeNum)/1000)