Discussion Board for collaboration related to Creating Analytics for QlikView.
two table-chart with different total mode. How can i format total in table-chart two on right side with correct format.
Go to Solution.
See attached, changed the label expression and in the presentation tab set the orientation to right
didn't get you, what is the desired output?
I undertand you want 1.250 instead 1,250
In expression use:
= 'Total ' & Num(Sum(Value),' #.##0')
In script you must change:
from presentaion tab--select ur field--set alignment as Right
Thanks, Total 1.250 is on left side in column and I need Total 1.250 on right side.
Change the Label From
= 'Total ' & Num(Sum(Value),' #,##0.', '.', ',')
= 'Total ' & Num(Sum(Value),'#.##0', ',', '.')
Just swapping the decimal and thousand seperators round
apply the above technique.
hey,whr is the orentaion in presentaion tab? very funny...
Values should be on right side, strings without values on left side!