topic Re: Wrong date format when export to Excel in QlikView

Wrong date format when export to Excel

Thu, 14 May 2015 16:43:16 GMT

Hello

when I just use date field from Dimension and export the table to excel everything working well.

but as soon that I am using a formula

=if(date> actual,date)

When Actual is a variable ==> 1/2/2015

and export to excel than the format in excel not ok.

I mean when I am filtering the date I don't see group like we should see for date "Year / month and than date"

but I see a lot of lines of date, You can see the picture attached.

I don't know what to do.

I hope that it was clear

thanks

Franck

m_woolf — Thu, 14 May 2015 18:02:00 GMT

Your dates are coming into Excel formatted as Text.

To convert in Excel, click column A and chcnge the format to Short Date.

Then select Data|Text to columns and click Finish

Instead of using Send to Excel:

If you are using the IE PlugIn, you can right-click and choose Copy to Clipboard|Full Table. Then paste into Excel

Right-Click and Export to csv. Then open in Excel.

Fri, 15 May 2015 07:39:02 GMT

THANKS A LOT

I was stuck with this during a long time,

HAVE a very nice weekend and thank you again