topic Problem in Date Formating in QlikView

Problem in Date Formating

Anonymous — Wed, 23 Jun 2010 05:10:43 GMT

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.

Problem in Date Formating

Wed, 23 Jun 2010 05:50:27 GMT

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

Problem in Date Formating

Anonymous — Wed, 23 Jun 2010 06:52:37 GMT

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

Problem in Date Formating

Wed, 23 Jun 2010 07:23:03 GMT

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

Problem in Date Formating

Wed, 23 Jun 2010 07:23:33 GMT

DO LIKE THIS

DATE#(DATE, 'MM/DD/YY') AS MYDATE AND U WILL GET THE DATE FORMAT

REGARDS

ABDALLA

Problem in Date Formating

sathishkumar_go — Wed, 23 Jun 2010 07:33:24 GMT

Try this date#(Date,'Date Format','MMM-YY') AS Date

-Sathish

Problem in Date Formating

Anonymous — Wed, 23 Jun 2010 08:03:13 GMT

Hi Lester,

Thanks very much - that'll do it!.

Problem in Date Formating

Anonymous — Wed, 23 Jun 2010 08:06:48 GMT

Satish,

Thanks for your reply but Your solution is not working. it is showing error in script.

Problem in Date Formating

sathishkumar_go — Wed, 23 Jun 2010 08:08:34 GMT

Hi Samay,

Can u attach ur application here?

-Sathish

Problem in Date Formating

Anonymous — Wed, 23 Jun 2010 08:08:44 GMT

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.

Problem in Date Formating

Anonymous — Wed, 23 Jun 2010 08:14:10 GMT

Hi Satish,

My application is attached in Lester reply.