Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 (2)
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.