Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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
Anonymous
Not applicable
Author

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 - Contributor II
Partner - Contributor II

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