Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
haymarketpaul
Contributor III

Week to Date Range on chart x-axis

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

Tags (1)
1 Solution

Accepted Solutions

Re: Week to Date Range on chart x-axis

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.


talk is cheap, supply exceeds demand
2 Replies

Re: Week to Date Range on chart x-axis

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.


talk is cheap, supply exceeds demand
haymarketpaul
Contributor III

Re: Week to Date Range on chart x-axis

Thanks for the reply - works perfectly.

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

Community Browser