topic Re: Chart Display Week Begin Date Instead of Week Number in QlikView

Chart Display Week Begin Date Instead of Week Number

sqlpuzzle — Fri, 15 Nov 2024 23:33:44 GMT

Hi,

I have a sample attached.

The issue that I am having is with displaying X-axis Labels, In the Weekly view of the cyclical chart. I would like to see labels like 02 Nov 2020, 09 Nov 2020, 16 Nov 2020 instead of numbers like 44, 45,46 ( week). I want the date of the Monday of the week displayed in the label.

How can this be achieved.

Re: Chart Display Week Begin Date Instead of Week Number

Kushal_Chawda — Wed, 25 Nov 2020 16:59:36 GMT

@sqlpuzzle create week like below

Weekstart(date,0,0) as week

Re: Chart Display Week Begin Date Instead of Week Number

sqlpuzzle — Wed, 25 Nov 2020 17:03:06 GMT

Thanks that helped.

Date(floor(WeekStart(date,0,0)),'DD MMM YYYY')as week

Re: Chart Display Week Begin Date Instead of Week Number

Kushal_Chawda — Wed, 25 Nov 2020 17:06:22 GMT

@sqlpuzzle yes, if you need different format then you can format it using Date function