Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Try with the dual fonction that's take two parameters, and weekstart fonction
Dual(weekstart(date.autocalendar.week),date.autocalendar.week)