Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sqlpuzzle
Contributor III
Contributor III

Chart Display Week Begin Date Instead of Week Number

Hi,

 

I have a sample attached.

The issue that I am having is with displaying X-axis Labels, In the Weekly view of the cyclical chart. I would like to see labels like 02 Nov 2020, 09 Nov 2020, 16 Nov 2020 instead of numbers like 44, 45,46 ( week).  I want the date of the Monday of the week displayed in the label.

How can this be achieved.

Labels (2)
1 Solution

Accepted Solutions
Kushal_Chawda

@sqlpuzzle  create week like below

Weekstart(date,0,0) as week

View solution in original post

3 Replies
Kushal_Chawda

@sqlpuzzle  create week like below

Weekstart(date,0,0) as week

sqlpuzzle
Contributor III
Contributor III
Author

Thanks that helped.

Date(floor(WeekStart(date,0,0)),'DD MMM YYYY')as week

Kushal_Chawda

@sqlpuzzle  yes, if you need different format then you can format it using Date function