Discussion Board for collaboration related to QlikView App Development.
=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?
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.
please upload your qvw
Can you try: =date([Fab Out Dt] + $(vDate),'M/D/YYYY')
I did below and it worked
Settings - Document Properties - tab Number. Select the date field and choose Date at the Number format settings