Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am creating an app for our sales team and have added a heatmap chart showing the last 16 full weeks and the current week using the following expression against the Weeks ago dimension
sum({<
[CalDate]={">=$(=NUM(WeekStart(Today(),-16)))<=$(=NUM(WeekEnd(Today(),0)))"},
>}
[Sales Invoice Line Value])
How do I get the label to show the week commencing date instead of the number of weeks ago as below
I know it is probably really simple but dates in Qlik really confuse me 😞