topic Re: Date Format for Y-Axis in QlikView

Date Format for Y-Axis

Mon, 25 Jun 2012 23:49:07 GMT

Hi, I'm trying to add a date format to the Y-Axis and have not found a way to do this can anyone help?

As you can see I have a set of numbers on the right axis that relate to the dates - I've tried all sorts of formating but got no where.

Am I missing something as simple and a date button

Thanks Rob

ver 11

Re: Date Format for Y-Axis

swuehl — Tue, 26 Jun 2012 00:15:58 GMT

Have you tried the date number format option in number tab in the chart properties?

Re: Date Format for Y-Axis

Tue, 26 Jun 2012 00:36:13 GMT

Yes I did, you would think that that would have solved it but no!

Very odd - something so simple.

Thanks

Rob

Re: Date Format for Y-Axis

Tue, 26 Jun 2012 20:37:56 GMT

Hi Sweuehl, throught plaing with the Static Min and Max and applying the date to the number format I have managed to get it to provide the year in intervals of 10 years.

It's a start - will keep going!

Thanks

Rob

Re: Date Format for Y-Axis

swuehl — Wed, 27 Jun 2012 08:40:48 GMT

AFAIR, QV will apply some of it's spare AI to the y-axis formatting, so depending on the range of values and the available real estate in the chart object, it will format the date as year only or using the full format specified (year, month, date). You can play around with limiting the range further or increasing the chart object to see the effect I am talking about.