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

Dimension - Date - display the actual day of the week

Hi - I am have  a line chart displaying the day of the week on the x-axis (dimension).

How can display the day of the week (such as Monday, Tuesday, etc..) as well ?

 

Thanks - Jerry

 

7 Replies
Vegar
MVP
MVP

You are displaying the day of the week as a dimension, but you also want it to be displayed in another way? How? Please explain.
jerryr125
Creator III
Creator III
Author

it is at the bottom of the line chart on the x-axis - displays as mm/dd/yyyy format

jerryr125
Creator III
Creator III
Author

it is displaying at the bottom of the page as mm/dd/yyyy.

I would like to display the day then the mm/dd/yyyy such as Monday, 06/10/2019

 

Is this possible ? Thanks - Jerry

Vegar
MVP
MVP

IF you format your date field as

Date(DateField, 'WWW mm/dd/yyyy')

and disable continous axis then you will get the presentation

image.png.

jerryr125
Creator III
Creator III
Author

hi - very very close...

 

I used the formula =Date([DATE], 'WWW mm/dd/yyyy')

and it is displaying the month as 00

 

thoughts ?

jerryr125
Creator III
Creator III
Author

got it 

=Date([DATE], 'WWW MMM/DD/YYYY')

Vegar
MVP
MVP

Great!
(I missed the part that you wanted the month shortname instead of a number)