topic Re: sort weekday based on todays date in QlikView

sort weekday based on todays date

qliklizzy — Sat, 16 Nov 2024 19:58:04 GMT

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

Re: sort weekday based on todays date

Frank_Hartmann — Thu, 03 Oct 2019 08:55:11 GMT

see here:

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

Re: sort weekday based on todays date

qliklizzy — Thu, 03 Oct 2019 09:06:06 GMT

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

Re: sort weekday based on todays date

asinha1991 — Thu, 03 Oct 2019 09:27:41 GMT

in the sort tab choose expression, and do ascending.

in the expression write

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

Re: sort weekday based on todays date

qliklizzy — Thu, 03 Oct 2019 09:45:36 GMT

Thanks

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

thanks

Re: sort weekday based on todays date

asinha1991 — Thu, 03 Oct 2019 10:03:40 GMT

I see try this , should work

easier maybe

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

Re: sort weekday based on todays date

qliklizzy — Thu, 03 Oct 2019 10:29:47 GMT

thanks again

sorry but it just says allocated memory exceeded?

Re: sort weekday based on todays date

Frank_Hartmann — Thu, 03 Oct 2019 15:55:57 GMT

whats the date format of your admissiondatemonth field?

Re: sort weekday based on todays date

qliklizzy — Fri, 04 Oct 2019 07:50:48 GMT

04/09/2019 11:57:00

Re: sort weekday based on todays date

Brett_Bleess — Thu, 10 Oct 2019 11:59:57 GMT

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/DateAndTimeFunctions/weekday.htm

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

Re: sort weekday based on todays date

StarinieriG — Thu, 10 Oct 2019 14:10:51 GMT

you could try in this way

Expression:

If(weekdayn>=$(DayToday), weekdayn-$(DayToday),$(DayToday)+1+weekdayn)

you need to

1) create the variable

DayToday = Num(Weekday(Today()))

2) create a field (or you could use the expression instead of weekdayn)

Num(WeekDay(date)) as weekdayn