topic Re: Calculated dimension date problem in QlikView

Calculated dimension date problem

Wed, 08 Oct 2014 19:14:14 GMT

=date([Fab Out Dt] + $(vDate)) .

I am able to generate date using this in calculated dimension in table...but as soon as I convert it in line chart i get numbers instead of date...

I have attached both chart and table image

table shows fine but as soon as I click on line chart it shows internal numbers. Is there a way to convert them to date on line chart?

Anonymous — Wed, 08 Oct 2014 19:22:14 GMT

What is comming on your variable vDate?

I did this same test here (with the same calculated dimension) and it worked fine.

If possible, upload here your qvw.

Regards,

Gabriel

arsal_90 — Wed, 08 Oct 2014 19:24:39 GMT

please upload your qvw

wernerprovelu — Wed, 08 Oct 2014 19:29:56 GMT

Hi Ria,

Can you try: =date([Fab Out Dt] + $(vDate),'M/D/YYYY')

Wed, 08 Oct 2014 22:10:28 GMT

Thanks all!

I did below and it worked

Settings - Document Properties - tab Number. Select the date field and choose Date at the Number format settings