Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
santhosh_k_n
Creator II
Creator II

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

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

QV_Comm_q.jpg

Please help on this

23 Replies
its_anandrjs

Export to excel works there is no problem you are asking or question about that.

Hope this helps

Thanks & Regards

Anonymous
Not applicable

hi Prashant

ive followed the same procedure but it isnt working still. i see text format when exported. could you please help

awaiting your response

thanks

Pancham

PrashantSangle

in which version are you trying??

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
chrigu
Contributor
Contributor

hi,

how can i change this on the qlikview server?

Thanks for the answer!

Chrigu