EXCEL EXPORT ISSUE

[madhukar_putta]

Hello all,

I am new for QLIKVIEW tech. I have an issue in my application. While I took option "SEND TO EXCEL" in any straight table or pivot table chart, the date format is changing in EXCEL sheet when data is in large content (Huge data).

Please find the excel for the screenshots. For small data there is no issue. Where as for large data this problem occurs. In the screen shot i marked it in RED colour.

In QVD'S date format was "DD-MM-YYYY" but in excel for dates below 12th was showing like "DD/MM/YYYY" as shown in image.  Please provide some solution for this. Thanks in advance.

[marcus_sommer]

Your excel-export returns for the dates string-values. Some of these values will from excel automatically converted into numeric values - see here the different horizontal alignment by string and numeric values. To solve this issue set in the object properties from the table under number tab the format explicitly on date.

- Marcus

[madhukar_putta]

Hello Marcus,

Thanks for the reply. I checked object properties, under number tab only expressions fields will available. But in my case all are dimensions in the chart. So please guide. Thanks.

[madhukar_putta]

Hello Marcus,

Thanks for the reply. I checked object properties, under number tab only expressions fields will available. But in my case all are dimensions in the chart. So please guide. Thanks.

[marcus_sommer]

You could also each dimension define - go to document properties and then to the tab numbers.

- Marcus

[jonathandienst]

Hi

I think Excel is expecting dates in MDY order, rather than the DMY that Qlikview is exporting. That's why Excel can convert dates before the 12th, as these are valid for MDY dates. Dates after the 12th are not valid. Excel is displaying MM/DD/YYYY dates, not DD/MM/YYYY dates.

Excel determines the date format from the regional settings on your PC. You can modify the model to export in MDY format, or change your regional settings to match the QV document.

Hope that helps

Jonathan

[ashwanin]

Hi Madhukar,

Open the QlikView model ,click on Edit Script and Change the Date and Time stamp Format.

Reload the model and send the data to excel.

rgds

Ashwani

[#8]

Hi Madhukar,

Have you tried to go to the Config menu, inside Document Properties option go to "Number" tab and select into the left column the date fields (PO_DATE, DDD_adj, etc.) that you are using and define the date format?

[madhukar_putta]

Hello Marcus,

I tried the option but still issue not solved. Is there any other way ?

[madhukar_putta]

Hello Merino,

Thanks for the reply.

I tried that option too but still not solved.