Solved: export format number - Qlik Community

Report Inappropriate Content · ‎2011-07-04

Hi,

I have defined the number format of one of my fields using document properties, the format is '###0.000000000'.

It works correctly when I show that field in dashboards and charts, but If I export a table to a .csv using "store" the format changes...

Any idea?

Thanks!!

kaushiknsolanki · ‎2011-07-04

Hi,

I dont know this will work or not, but you can give a try.

Go to Settings -> User Preferences -> Export -> Number Formatting. Select Full Formatting.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

kaushiknsolanki · ‎2011-07-04

Hi,

I dont know this will work or not, but you can give a try.

Go to Settings -> User Preferences -> Export -> Number Formatting. Select Full Formatting.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-07-04

Thanks but It doesn't work...

kaushiknsolanki · ‎2011-07-04

Hi,

Can you upload the qvw file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-07-06

it was working propperly, my fault...

hectorvega · ‎2015-01-08

Also does not work on exporting as HTML... Qlikview omit the comma. Not dolar sign.

Is this a bug?

export format number