topic Re: Week to Date Range on chart x-axis in QlikView

Week to Date Range on chart x-axis

haymarketpaul — Mon, 03 Dec 2012 12:17:45 GMT

Hi All

QV11 SR1

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

eg...

week 2 - 24/09/2012 - 30/09/2012

week 3 - 01/10/2012 - 07/10/2012

week 4 - 08/10/2012 - 14/10/2012

etc

Any ideas welcome

Gysbert_Wassenaar — Mon, 03 Dec 2012 12:24:40 GMT

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.

haymarketpaul — Mon, 03 Dec 2012 12:32:39 GMT

Thanks for the reply - works perfectly.

Yes i'm going to display in a table which like you say will look much nicer.