Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
astitzel
Partner - Contributor II
Partner - Contributor II

Format AutoCalendar Date for Labels

Hi all! 

I am building out a velocity chart to show data by month with the capability to drill down to the week level. The dimension is calculated using Qlik's autoCalendar.Week field. Is there any way to reformat the labels on the x-axis to reflect the first day of the week in DD/MM/YY format as opposed to the week number?

velocity.PNG

 

Labels (3)
1 Reply
brunobertels
Master
Master

Hi,

Try with the dual fonction that's take two parameters, and weekstart fonction 

Dual(weekstart(date.autocalendar.week),date.autocalendar.week)