sort weekday based on todays date

[qliklizzy]

Hi

I have a table of counts over the last 7 days, sorted mon tues wed...etc

is there a way of sorting by today onwards, So today is Thursday - start the sort on Friday

thanks

[Frank_Hartmann]

see here:

https://community.qlik.com/t5/QlikView-App-Development/Sorting-Weekday-Dynamically/m-p/1630412#M4464...

[qliklizzy]

Hi thanks for quick reply, I don't think its quite worked;

I have this as my dimension

=if(AdmissionDateMonth >= today()-7,weekday(AdmissionDateMonth))

if I replace with test it doesn't show results corrrect

[asinha1991]

in the sort tab choose expression, and do ascending.

in the expression write

fabs(num(weekday(AdmissionDateMonth))-num(weekday(today())))-(num(weekday(AdmissionDateMonth))/10)

[qliklizzy]

Thanks

tired that -  it starts on Tuesday and then goes thurs, wed, fri, sat, sun, mon?

thanks

[asinha1991]

I see try this , should work

easier maybe

sum(if(weekday(AdmissionDateMonth)>weekday(today()),num(weekday(AdmissionDateMonth))-8,num(weekday(AdmissionDateMonth))))

[qliklizzy]

thanks again

sorry but it just says allocated memory exceeded?

[Frank_Hartmann]

whats the date format of your admissiondatemonth field?

[qliklizzy]

hi

04/09/2019 11:57:00

[Brett_Bleess]

Elizabeth, have a look at the following Help link, I think using a variable based upon Today() that you then use in the first_week_day variable may adjust things on-the fly, might be an easier solution, but I did not play with things, so I am not sure if it will actually work or not, but I wanted to toss it out.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...

Found a Design Blog post that may be helpful too:

https://community.qlik.com/t5/Qlik-Design-Blog/Redefining-the-Week-Start/ba-p/1473588

Regards,
Brett