Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

shivani_singhal
New Contributor II

Finding issue while downloading any table in excel file on browser.

Hi Everyone,

I am facing a problem in downloading the tables in Excel on browser. I am using [ 11.20.12852 SR11 ] Qlikview version. When I click to send to excel option on desktop. It downloads in proper format. But when I download it through Browser, it converts the number values to text. Kindly help me out with this issue.

Thanks and Regards,

Shivani Singhal

2 Replies
techvarun
Valued Contributor II

Re: Finding issue while downloading any table in excel file on browser.

number stored as text in Excel based report | Qlik Community

You need to format the expression as number to solve the issue.

Use Num() or format it on the number tab on properties window.

shivani_singhal
New Contributor II

Re: Finding issue while downloading any table in excel file on browser.

I have already done it. I used num() function in expression. Changed the properties in number tab. Also changed the properties in Document Settings and set it to number. Plus done the settings in Help option in About QlikView in easter cell. But after setting all these properties I am facing the same issue.

Community Browser