topic Number format in QlikView

Number format

Mon, 28 Jun 2010 20:49:10 GMT

Hi,

I get an error 'Format error' when exporting to excel. So, I tried changing the format of each expression and I got rid of the error, but I am unable to maintain the number format.

1) I included Num(<Expression>, '#,##0') in all the expression. Eventhough the front end of the application looks good and I didn't have any error while exporting, but the number format is changed to '########' (without any comma) in the excel sheet.

Is there any other format (with Commas) which will work both in the front-end and while exporting too.

Number format

Mon, 28 Jun 2010 21:00:34 GMT

Are you using chart?

If so then in the chart property , on NUMBER tab use either integer or number and on separaters use .(perioed) and ,(comma), that should work when you export.

Number format

Mon, 28 Jun 2010 21:12:35 GMT

Yes. I use the chart, but the problem started only when I entered on Number tab. I get error when exporting to excel sheet, when I give integer or decimal format and hence I changed to 'expression default' and that is why I am changing the number format in the expression itself.