topic number format on total in QlikView

number format on total

amien — Sat, 19 Feb 2011 22:28:54 GMT

is it possible to give the total of the bar chart a own number format? so i need on all values 0.0 .. instead the total . that needs to be 0.000

vgutkovsky — Sun, 20 Feb 2011 06:04:12 GMT

To check if you're on the total row, use if(rowno()=0,num(expression,'#.###'),num(expression,'#,#'))

Regards,

amien — Sun, 20 Feb 2011 12:06:37 GMT

Thanks for your reply .. but..

that only works on a pivot .. not on a bar chart

Sun, 20 Feb 2011 13:42:42 GMT

Hi Amien,

try Dimensionality() instead. It worked for before in colouring the bars differently, maybe it behaves the same for you.

cheers

Florian

amien — Sun, 20 Feb 2011 15:30:07 GMT

Nope .. total doesnt react

vgutkovsky — Sun, 20 Feb 2011 23:23:35 GMT

rowno()=0 works on bar charts as well. Dimensionality, by contrast, works only on pivot tables.

Regards,