Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dlesny
Contributor II
Contributor II

Week Start date from dates

Hello

I have 2 questions which I am trying to resolve without success. I would appreciate help

1. I would like to view my data week by week for which I am using "week" or "WeekYear" but how can I display a "dd/mmm" for each column instead of week number "24" for example?

 

2. I need a vertical Reference line on week 24 (10th June 2020 to be specific)

 

Please help

Labels (3)
2 Replies
dlesny
Contributor II
Contributor II
Author

Got the answer for my 1st question 🙂

date(WeekStart(TempDate),'DD-MMM') as WeeklyDate

but I still can't figure out how to get the Vertical line at the 10/June week.

Brett_Bleess
Former Employee
Former Employee

Best I have is the following Help link:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Reference_Lines...

Not sure it is going to do what you want, the only other thing of which I can think would be to overlay a line on top of the chart object marking things, but I do not know if that will work for you or not.  

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Line_Arrow_Obje...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.