Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a numeric string of date which i loaded in my application. when i am writing expression "date(Date,'MMM-YY')" . Date is showing in correct format in graph but when i am exporting it as excel(send to excel) , date is in numeric. is there any way to get it in right format.
Hi samay!
I think that will only change the date format in QlikView graph, but not when you exported it. I suggest you to make official date format in your script that you will use. Like:
date(Date, 'MMM-YY') as myDate
And the use "myDate" for your Table and Graphs..
Hope that can help you solve your problem
-Lester
Hi Iprosete ,
Thanks for your reply. i have tried your solution but it is not working.Here is my Qlikview file.
http://community.qlik.com/media/p/117910.aspx
Hi Samay!
Yeah, I saw your QV file and I was surprised that you posted your .qvw to "Shared QlikViews".. Anyways, I can' t see the original date format since it is not attached, so I'm giving you other solution for your problem. I added a "Fast Type Change" on your Graph, its now Line Graph and Straight Table. Switch to Straight table first before exporting it to Excel.
I already tried it and it worked.. And I think adding one click isn't a problem..
- Lester
HI
DO LIKE THIS
DATE#(DATE, 'MM/DD/YY') AS MYDATE AND U WILL GET THE DATE FORMAT
REGARDS
ABDALLA
Hi
Try this date#(Date,'Date Format','MMM-YY') AS Date
-Sathish
Hi Lester,
Thanks very much - that'll do it!.
Satish,
Thanks for your reply but Your solution is not working. it is showing error in script.
Hi Samay,
Can u attach ur application here?
-Sathish
Hi Abdullah,
Thanks for your reply but Your solution is not working. When i am expoting the data from excel, date format comes in numeric value.