Number field is exported as text in excel file after export`

[santhosh_k_n]

Hi All,

I am using a pivot table in one of my doc and in dimensions one of the dimension is calculated dimension which is in number format

On exporting to excel, values of the calculated column is presented as text and options it pop outs as follows

Please help on this

[#2]

In the calculated dimension, try multiplying the entire result by 1

(exp)*1

[tresesco]

Right click on the table-> Copy to Clipboard->Full Table, and then paste in excel.

[santhosh_k_n]

Sorry Graeme,

Even that didnt work.

More over the calculated dimensions are using num() function

[santhosh_k_n]

This works fine as a developer prospective.

But by end user prospective its not suggestable

[PrashantSangle · Accepted solution]

Hi,

You can do this thing by go to,

Help->About Qlikview->(Right Click on) Qlikview Symbol(On Left Bottom)->ExcelExportMixedAsText(Select)->Set its value as 0 ->Set->Close

Save your qlikview Document and then Export chart to Excel,

This will surely help you

Regards,

[santhosh_k_n]

Thanks Max.

This works fine.

But will this effect any other properties in the document

[its_anandrjs]

Hi,

See the attached snap and change value here Max is given answer for this

Hope this helps

Thanks & Regards

[PrashantSangle]

Hi,

It will affect on only those data who have combination number and string .

Other wise it works fine

Regards,

[santhosh_k_n]

another question: I had saved this file and distributed to some users.

From accsspoint if i export to excel will it work

[PrashantSangle]

Hi,

As per my knowledge it should work.

Regards,