topic Straight table dimension format in QlikView

Straight table dimension format

Wed, 05 Dec 2012 15:53:20 GMT

Hi,

I've got a straight table. I am able to change the format for expressions on Number tab in Properties.

How would I change the data format for dimensions?

I have some fields which need to be displayed as currency. At the moment, data is only displaying as numbers.

Thanks

CELAMBARASAN — Wed, 05 Dec 2012 16:00:30 GMT

You need to add as calculated dimension

like Num(CurrencyField,'$###,###.##')

Hope it helps

Wed, 05 Dec 2012 16:09:32 GMT

Thanks for this. Had to change it a little bit to:

=Num(Currency_Field, '£#,##0;-£#,##0')

Thanks for your help!