Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
in the sort tab choose expression, and do ascending.
in the expression write
fabs(num(weekday(AdmissionDateMonth))-num(weekday(today())))-(num(weekday(AdmissionDateMonth))/10)
Thanks
tired that - it starts on Tuesday and then goes thurs, wed, fri, sat, sun, mon?
thanks
I see try this , should work
easier maybe
sum(if(weekday(AdmissionDateMonth)>weekday(today()),num(weekday(AdmissionDateMonth))-8,num(weekday(AdmissionDateMonth))))
thanks again
sorry but it just says allocated memory exceeded?
whats the date format of your admissiondatemonth field?
hi
04/09/2019 11:57:00
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.
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