Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Text change to number in table export data

Hi, Guys

When I export table data to excel

ProductQTY
001210
ad1215

the product 0012 will change to 12, how to solve this problem

BTW, what is the result when there are two items (0012 and 012) export data to excel

keep two rows 12 or combine into one rows?

6 Replies
igdrazil
Contributor III

Re: Text change to number in table export data

Hi Jarven,

Excel will automatically "delete" preceding zeros so i guess you'll have to put something upfront of that product (maybe a # sign or smth).

you could do this by putting in your dimension field:

"=# & Product" without the " "-signs

Regards

Chris

Not applicable

Re: Text change to number in table export data

Thanks for your suggestion

But plus # will coufuse user

Is there other solution ?

igdrazil
Contributor III

Re: Text change to number in table export data

You can manually change the cell format in excel and then fill the missing zeros manually, too.

If you use the #-version you can edit the cells in excel afterwards via the right function and cut off that #-sign.

This would be a bit laborious but it would work.

How many rows do you have in your Product column

Regards

Chris

simondachstr
Valued Contributor III

Re: Text change to number in table export data

Try formatting the Product dimension as Text() in the script.

Text(Product) AS Product

Not applicable

Re: Text change to number in table export data

I have already text the Product in the ETL, the problem is export to Excel

It is shows 0046 in Qliksense while it changed to 46 when export to Excel

Not applicable

Re: Text change to number in table export data

3w records per month

So I try to find some method to change the setting of export to Excel

Community Browser