Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

New "day" in day names

all,
I'm trying to create a new day name, but I'can't xD!!!
the example is this: I create a new day name "today", so in chart i can graph day names vs money.... and i can compare "today" whit the average of the week...
But I'need to put the day "today" in the "SET NameDays"... i doed, but the system don't recognize the new day....
the final idea is to use this function: if( weekday(date)='today',1,2) as 3
the problem is the function weekday(), because the result is an integer, so.... how can i do to the function give "7" as result and asociate whit the day name "today" ????????????
who knows how to edit the calendar ?? if you know what i mind....thanks

1 Reply
swuehl
MVP
MVP

I don't think you can extend the existing weekday function like that..

Could you explain what you want to achieve / what's your business problem is?

It might be easier to help you with your problem then.

For example, if you want to create a dimension with all weekdays and additional 'today' as comparison but based on a Date (OrderDate or whatever), you could maybe use a calculated dimension like

=if(Date=today(),'Today',WeekDay(Date))

Regards,

Stefan