topic date with weekday on date-axis in Chart in QlikView

date with weekday on date-axis in Chart

Thu, 29 Mar 2012 09:02:26 GMT

Hi,

I have a chart with dates on the dimension axis. And I just want to display the weekday of the day beside/below/what else to the date. How can I add this information to the chart?

So on the dimension axis I want: 2012-03-29 (Thu), 2012-03-30 (Fr), ...

Thanks for your help.

Arne

Re: date with weekday on date-axis in Chart

Thu, 29 Mar 2012 10:41:03 GMT

On the Number tab of the chart properties, select the dimension field, tick the box "Override Document Settings" and set the format to Date. Then on the right hand side set the Format Pattern to "YYYY/MM/DD (WWW)" and that should do it.

Matt

Re: date with weekday on date-axis in Chart

Thu, 29 Mar 2012 10:55:22 GMT

Hi Matt,

on the Number tab I don't have the possibility to change the dimension field, only the formulas.

Arne

Re: date with weekday on date-axis in Chart

Thu, 29 Mar 2012 11:11:17 GMT

Sorry my mistake. You can either format the date field in the script instead using the date() function like this:

date(MyDateField, 'YYYY/MM/DD (WWW)') AS MyDateField

or you could use a calculated dimension within the chart to do the same like this:

=date(MyDateField, 'YYYY/MM/DD (WWW)')

but calculated dimensions are best avoided though as they can cause poor performance if you have large volumes of data.

Regards

Matt

date with weekday on date-axis in Chart

SunilChauhan — Thu, 29 Mar 2012 11:18:09 GMT

weekday('2012-03-29')(fieldname)

ex:

weekday('2012-03-29')-> Thus

hope this helps

Re: date with weekday on date-axis in Chart

Thu, 29 Mar 2012 11:22:42 GMT

Hi Matt,

thanks, that solved it.

regards

Arne

Re: date with weekday on date-axis in Chart

Thu, 29 Mar 2012 13:42:28 GMT

No problem!