Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
sofiavaz
Contributor

Weekday function

Hi all,

Does anybody know a way to label a date by weekday, when it is been using as a dimension? I have a bar chart in which the dimension is a date. Besides having the date, i wanted to show the correspondent weekday, eg, Thu 08-03-2018.

I know the weekday() funtion, but the problem with this function is that it aggregates all mondays, all tuesdays, etc and that's not what's needed.

Does anyone have a suggestions to this?

Thank you!

1 Solution

Accepted Solutions
MVP
MVP

Re: Weekday function

Try to format your date like

Date(DateField,'WWW DD-MM-YYYY')

5 Replies
MVP
MVP

Re: Weekday function

Try to format your date like

Date(DateField,'WWW DD-MM-YYYY')

YoussefBelloum
Esteemed Contributor

Re: Weekday function

Hi,

try this:

=WeekDay(Date)&'-'&Date

sofiavaz
Contributor

Re: Weekday function

It works perfectly! Thank you very much.

sofiavaz
Contributor

Re: Weekday function

Thank you youssef. Probably this function also works, but i couldn't sort the dates properly...

YoussefBelloum
Esteemed Contributor

Re: Weekday function

you're welcome. of course you can, you can always use Max(Date) ascending on the sorting expression.