Chart labels

[Batgirl_93]

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 😞

[Jaroslav_Stsetinin]

You  can use the following function https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/DateAnd... 

Bear in mind that Heatmap extension is not supported since Feb 2022 version https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Visualizations/Visua.... You can use Grid chat instead.