Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Changing Number Format

Hello,

I would like to change the number format of a Column in a Chart Straight Table. I select the column under dimensions because I have to suppress it when the value is null. (I know its possible if I select it as an expression).

I assume I can adjust the format also of a dimension but I'm a bit confused here, I see 'Text Format' but do not know what code I should type to set it correct.  (Needs to be money-format)

Txs

1 Solution

Accepted Solutions
vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi,

You can use the calculated dimension  =Num(FieldName,'£#,##0.00;(£#,##0.00)')

Regards

VIjay

View solution in original post

4 Replies
vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi,

You can use the calculated dimension  =Num(FieldName,'£#,##0.00;(£#,##0.00)')

Regards

VIjay

Sokkorn
Master
Master

Hi,

With your dimension =MONEY(Field)

Regards,

Sokkorn Cheav

Not applicable
Author

Thanks a lot for this quick response!

Helps me a great deal

Not applicable
Author

Works also!