topic Chart Dimension: Text format in QlikView

Chart Dimension: Text format

danosoft — Mon, 09 Jul 2018 14:52:06 GMT

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

Re: Chart Dimension: Text format

m_woolf — Mon, 09 Jul 2018 15:05:30 GMT

Try using num()

Re: Chart Dimension: Text format

danosoft — Mon, 09 Jul 2018 15:08:52 GMT

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);-')

Re: Chart Dimension: Text format

vishsaggi — Mon, 09 Jul 2018 15:12:05 GMT

you can use Money() function too.

Re: Chart Dimension: Text format

danosoft — Mon, 09 Jul 2018 15:12:48 GMT

Thanks