Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Contributor III

Chart Dimension: Text format

I have this problem, i have a chart with some Dimensions and some Expressions; so for Expression i can in the tab number set the formatting (like you see in the picture), but in the Dimension i not have that kind of thing... how can i format my dimension for make it visible in this format:  #.##0,00;(#.##0,00);-    ? thanks

1 Solution

Accepted Solutions
Highlighted
Contributor III

Re: Chart Dimension: Text format

I find it, need to use NOT in Text format but directly in the Dimension expression in this way:

=Num(GEN_CONSUMO_MENSILE,'#.##0,00;(#.##0,00);-')

View solution in original post

4 Replies
Highlighted
Honored Contributor II

Re: Chart Dimension: Text format

Try using num()

Highlighted
Contributor III

Re: Chart Dimension: Text format

I find it, need to use NOT in Text format but directly in the Dimension expression in this way:

=Num(GEN_CONSUMO_MENSILE,'#.##0,00;(#.##0,00);-')

View solution in original post

Highlighted
Esteemed Contributor III

Re: Chart Dimension: Text format

you can use Money() function too.

Highlighted
Contributor III

Re: Chart Dimension: Text format

Thanks