topic Re: Qlikview sends to excel dimensions as text instead of num or date in QlikView

Qlikview sends to excel dimensions as text instead of num or date

Thu, 11 Sep 2014 10:18:33 GMT

Hi all,

I have an issue with formatting when sending to excel and I was hoping someone can help. I have a table with several dimensions and expressions. When I send to excel, a couple of number and date columns always come out as text. Is there any way to force the format when exporting to excel?

Thanks

Re: Qlikview sends to excel dimensions as text instead of num or date

tresB — Thu, 11 Sep 2014 10:25:36 GMT

From Qv desktop->Help->About QlikView->at the left bottom of new window qlikview symbol(easter egg)->Right click->ExcelExportMixedAsText ->Set it to '0'

Re: Qlikview sends to excel dimensions as text instead of num or date

PrashantSangle — Thu, 11 Sep 2014 10:27:16 GMT

Hi,

There is one way

Go to Help Menu->select About Qlikview->right Click on Qlikview Symbol(Which you found in left Bottom corner)

->Then Setting Screen Will appear->select ExcelExportMixedAsText->change it to 0

Regards

Re: Qlikview sends to excel dimensions as text instead of num or date

Thu, 11 Sep 2014 10:47:33 GMT

Thanks,

that did fix the number issue but now dates come out as numbers too (unless if I explicitly say Date() in the dimension).Is there another way to get around this for dates?

Re: Qlikview sends to excel dimensions as text instead of num or date

PrashantSangle — Thu, 11 Sep 2014 10:51:30 GMT

No,

For Date Field you have to explicitly Convert it that it is Date by using Date()

Regards

Re: Qlikview sends to excel dimensions as text instead of num or date

tresB — Thu, 11 Sep 2014 10:52:59 GMT

Goto Settings->Document Properties->Number(Tab)->Select date field->Set Number Format Setting as 'Date'.

Re: Qlikview sends to excel dimensions as text instead of num or date

srchilukoori — Mon, 11 May 2015 16:42:33 GMT

The fix suggested by treseco worked. thank you.

Re: Qlikview sends to excel dimensions as text instead of num or date

pradeep92 — Fri, 30 Nov 2018 11:47:06 GMT

Hi, This is not happening when I download the data from access point. the issue still exists

Re: Qlikview sends to excel dimensions as text instead of num or date

TonyCook — Thu, 24 Jan 2019 15:00:24 GMT

Hi ,

This approach works fine for me (Desktop as well as Access point).But, the settings are not reflected for other Users

Thanks ,

Veda