Week number to Week dates

[MK_8]

Hi, I am new to Qlik sense, and I wanted to check how we can change the week numbers (2021/41) into dates (11/10/2021 -17/10/2021). 

I Used WeekName(Date,0,1)  

I would appreciate it if someone could help me  

[justISO · Accepted solution]

Hi, you can try to use WeekStart() and WeekEnd() functions, like

WeekStart(Date) &' - '&WeekEnd(Date)

[rubenmarin · Accepted solution]

Hi, you can use: Date(WeekStart(Date)) &' - '&Date(Floor(WeekEnd(Date))).

But that will be too long to show on the label, maybe you can only use the start date (and the start of the next bar tells the user when the previous bar ends: WeekStart(Date).

You can show the full dates in the pop-up of the bar (Properties -> Appearance -> Tootip -> title or description)

[MK_8]

Thank you so much, it worked 😀