Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
TinaH
Contributor III
Contributor III

German Weekdays without Point

Hi,

I am using the weekday()-function to return the weekdays of a given date. So for instance, a Monday is displayed as "Mo.".

How can I remove the "." after "Mo." to just receive "Mo" as weekday?

Thank you!

Labels (1)
1 Solution

Accepted Solutions
justISO
Specialist
Specialist

Hi, you can replace dot to nothing with replace(weekday(),'.','')

or take only 2 left symbols of it with (left(weekday(), 2))

or in load script, 'Main' tab modify your representation of 'DayNames'

View solution in original post

2 Replies
Mark_Little
Luminary
Luminary

Hi,

The day names should be set in the script on the main tab. normally looks like this

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

I assume you will see 

SET DayNames='Mo.;Tu.;We.;Th.;Fr.;Sa.;Su.';

Change it to what you need and reload

justISO
Specialist
Specialist

Hi, you can replace dot to nothing with replace(weekday(),'.','')

or take only 2 left symbols of it with (left(weekday(), 2))

or in load script, 'Main' tab modify your representation of 'DayNames'