Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a chart that happily displays Number of User Logins by Week Number (see attached)
Instead of displaying the week number on the x axis i would like to display the date range for that week.
Week 1 starts on the 17th Sept 2012.
For example in the attached qvw instead of week 1 on the x axis it would display 17/09/2012 - 23/09/2012 and so on
week 2 - 24/09/2012 - 30/09/2012
week 3 - 01/10/2012 - 07/10/2012
week 4 - 08/10/2012 - 14/10/2012
Any ideas welcome
Try changing the dimension Week Number to the expression:
=dual(WeekStart([LoginDate]) & ' - ' & WeekEnd([LoginDate]),[Week Number])
BTW, it looks pretty horrible in the chart. You're better off with the weeknumbers imho. In a table it'd be ok.
View solution in original post
Thanks for the reply - works perfectly.
Yes i'm going to display in a table which like you say will look much nicer.