topic Re: Sorting order by expression for today() function in App Development

Sorting order by expression for today() function

bartdeboed — Sat, 16 Nov 2024 07:39:16 GMT

Hi all,

So I am looking for a different way to order weekdays. I want the weekday of today to be the first in a barchart. Today is a friday for example, so I want the figure to display: fri - sat - sun - mon - tue - wed - thu.

This is what I am currently trying, but it gives a wrong, random order:

=IF(weekday([datefield])=weekday(today()),1,

IF(weekday([datefield])=weekday(today()+1),2,

IF(weekday([datefield])=WeekDay(today()+2),3,

IF(weekday([datefield])=weekday(today()+3),4,

IF(weekday([datefield])=weekday(today()+4),5,

IF(weekday([datefield])=weekday(today()+5),6,7))))))

I'm looking forward to seeing your solutions! Thanks in advance.

Re: Sorting order by expression for today() function

mikaelsc — Fri, 14 Sep 2018 18:52:38 GMT

Hi Bart,

the most simple/clean would be, i guess, to change this variable in the load script: (this of course means it will be applied everywhere in your app)

SET FirstWeekDay=0;

change that to: SET FirstWeekDay=4;

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/NumberInterpretationVariables/FirstWeekDay.h…

so when sorting your days, you'll get fridays first:

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/weekday.htm

Re: Sorting order by expression for today() function

mikaelsc — Fri, 14 Sep 2018 18:54:19 GMT

ow and if you want that to be "dynamic" per reload day,

let FirstWeekDay= weekday(today());

Re: Sorting order by expression for today() function

thakkarrahul01 — Sat, 15 Sep 2018 20:44:54 GMT

You can add Week Sort Order column in your table where you will specify incremental number for each weekday and add that sort order using new derived column in chart properties as required. Sorting weight for today will be required to be calculated assuming your app is refreshed on daily basis.

This should give you custome sort option.

Régards,

Rahul