Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

udaya_kumar
Valued Contributor

Problem in comma format in export using macro

Hi,

I have set of 3 straight table, one below another.

I am exporting the tables using macro.

The table has some whole numbers with comma like 4,500 or 15,000.

but after i export it, in excel it shows 4500 or 15000.

There is no comma format applied in excel. what might be the problem?

can someone help?

Tags (2)
1 Reply

Re: Problem in comma format in export using macro

Export to excel exports only the data, not the formatting. You'll have to add the code for that to the macro yourself. See here for an example.


talk is cheap, supply exceeds demand
Community Browser