topic Issue in excel export// data not coming in number format in QlikView

Issue in excel export// data not coming in number format

jyothish8807 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have a straight chart , in which i am showing data as both (%, and as normal number) and it is working fine is QlikView.

But when i export the table into excel the data comes in text format in excel.

Please find the attached dummy application. I am using "pick (match" in my scenario to meet my requirements.

Any suggestions and help will be really appreciated.

Regards

Re: Issue in excel export// data not coming in number format

swuehl — Wed, 18 May 2016 10:45:37 GMT

Seems to work at my place, using 11.20 SR11 X64

Re: Issue in excel export// data not coming in number format

jyothish8807 — Wed, 18 May 2016 10:51:38 GMT

Hi Stefan,

In the export i want output in "%" format and one entry in normal number format as same in table.

Regards

Re: Issue in excel export// data not coming in number format

Anonymous — Wed, 18 May 2016 10:55:23 GMT

did you try to define the Format in tab number of straight table?

if the column is defined as dimension you may goto "document properties" and tab number and define the

field as number field

Re: Issue in excel export// data not coming in number format

jyothish8807 — Wed, 18 May 2016 14:05:11 GMT

Hi Rudolf,

I have tried the option, but no luck . The challenge over here is i have value in both "%" and Number format and i want to export in to excel in same format.

Regards

Jyothish KC

Re: Issue in excel export// data not coming in number format

Anonymous — Wed, 18 May 2016 14:12:59 GMT

did you try to format the columns explicit?

num(field,'##.##')

num(field,'#.##0,0%')

Re: Issue in excel export// data not coming in number format

swuehl — Wed, 18 May 2016 14:24:53 GMT

Jyothish,

sorry, I've misunderstood your request initially.

AFAIK, QV is still limited in keeping the default expression format.

Have a look at attached document to see if the export as text option is maybe of any help.

You might also find a solution using a macro to export your table to excel, maybe starting from

Export to Excel via macro-number format

But I think this macro would need to evaluate the requested format from the expression in the context of your dimensions.

Re: Issue in excel export// data not coming in number format

Anil_Babu_Samineni — Wed, 18 May 2016 14:28:44 GMT

Hey,

Might be you need to change like below...

And then try to send excel....

Re: Issue in excel export// data not coming in number format

jyothish8807 — Mon, 23 May 2016 07:00:18 GMT

Thanks a lot Stefan . The attachment was really helpful.

Hope Qlik will implement this feature in coming releases.

Regards

Re: Issue in excel export// data not coming in number format

Anonymous — Wed, 04 Jan 2017 16:26:23 GMT

Thanks for sharing the trick.

But it seems does not work for QV 11.20 SR15.

Zhihong

Re: Issue in excel export// data not coming in number format

Sun, 15 Jan 2017 20:41:15 GMT

I have QV release 11 SR8. Expression is set to fixed number with 2 decimals that is exported using macro to excel cells with format number with 2 decimals. Any advices are not functioning, expression is exported as text. I can say I am desperate for this product.