https://community.qlik.com/t5/App-Development/Format-AutoCalendar-Date-for-Labels/m-p/1692854#M52960 <P>Hi all!&nbsp;</P><P>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.&nbsp;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?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="velocity.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/31702i4A0D9DEBA5A9E652/image-size/large?v=v2&amp;px=999" role="button" title="velocity.PNG" alt="velocity.PNG" /></span></P><P>&nbsp;</P> Sat, 16 Nov 2024 18:47:40 GMT astitzel 2024-11-16T18:47:40Z https://community.qlik.com/t5/App-Development/Format-AutoCalendar-Date-for-Labels/m-p/1692854#M52960 <P>Hi all!&nbsp;</P><P>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.&nbsp;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?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="velocity.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/31702i4A0D9DEBA5A9E652/image-size/large?v=v2&amp;px=999" role="button" title="velocity.PNG" alt="velocity.PNG" /></span></P><P>&nbsp;</P> Sat, 16 Nov 2024 18:47:40 GMT https://community.qlik.com/t5/App-Development/Format-AutoCalendar-Date-for-Labels/m-p/1692854#M52960 astitzel 2024-11-16T18:47:40Z https://community.qlik.com/t5/App-Development/Format-AutoCalendar-Date-for-Labels/m-p/1692864#M52962 <P>Hi,</P><P>Try with the dual fonction that's take two parameters, and weekstart fonction&nbsp;</P><P>Dual(weekstart(date.autocalendar.week),date.autocalendar.week)&nbsp;</P> Sun, 12 Apr 2020 15:23:25 GMT https://community.qlik.com/t5/App-Development/Format-AutoCalendar-Date-for-Labels/m-p/1692864#M52962 brunobertels 2020-04-12T15:23:25Z