Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated dimension date problem

=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?




4 Replies
gabriel_kirst
Creator III
Creator III

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
Creator III
Creator III

please upload your qvw

wernerprovelu
Partner
Partner

Hi Ria,

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

Not applicable
Author

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