Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-05-05 11:21 AM

Export to excel changes date to text

Hello Experts,

I am using QlikView version 12 SR1. I am still having trouble when you choose export to excel, it changes date to text.

Capture.PNG

I know the work around to right click and copy full table to clip board and paste to excel sheet. But what about on the access point.

Any help is appreciated. Have a good one!

Thank you,

Parth

637 Views
0 Likes
1 Reply
t_witzgall
Partner - Contributor III
Partner - Contributor III
‎2018-01-03 05:51 AM

Hi,

I have the same problem. I am using QV 12.10 SR 6.

We use a pivot table which provides data for other excel sheets. If I use the workaround my formulas will no longer work because you get one big column:

So A2 has the date but A3 - A7 don't .. same with A9-A22.

Any ideas on that?

In QV 11 SR2 there was a similar problem which was mentioned to be a bug: Export to excel changes the date to text format

So is this a bug with QV 12 / 12.10?

Regards

Tamara

408 Views
0 Likes