topic Re: Format Total in QlikView

Format Total

Anonymous — Tue, 14 Apr 2015 14:35:31 GMT

Hi,

two table-chart with different total mode. How can i format total in table-chart two on right side with correct format.

Regards Stefan

maleksafa — Tue, 14 Apr 2015 14:39:27 GMT

didn't get you, what is the desired output?

fvelascog72 — Tue, 14 Apr 2015 14:43:03 GMT

I undertand you want 1.250 instead 1,250

In expression use:

= 'Total ' & Num(Sum(Value),' #.##0')

In script you must change:

SET ThousandSep='.';

SET DecimalSep=',';

buzzy996 — Tue, 14 Apr 2015 14:46:59 GMT

from presentaion tab--select ur field--set alignment as Right

Anonymous — Tue, 14 Apr 2015 14:47:28 GMT

Thanks, Total 1.250 is on left side in column and I need Total 1.250 on right side.

stigchel — Tue, 14 Apr 2015 14:47:39 GMT

See attached, changed the label expression and in the presentation tab set the orientation to right

awhitfield — Tue, 14 Apr 2015 14:47:45 GMT

Hi Stefan,

Change the Label From

= 'Total ' & Num(Sum(Value),' #,##0.', '.', ',')

TO:

= 'Total ' & Num(Sum(Value),'#.##0', ',', '.')

Just swapping the decimal and thousand seperators round

Andy

buzzy996 — Tue, 14 Apr 2015 14:49:16 GMT

apply the above technique.

buzzy996 — Tue, 14 Apr 2015 14:56:43 GMT

hey,whr is the orentaion in presentaion tab? very funny...

Anonymous — Tue, 14 Apr 2015 15:10:58 GMT

Values should be on right side, strings without values on left side!

buzzy996 — Tue, 14 Apr 2015 15:15:01 GMT

friend,that's alignment not orientation..that's ' wht I said in the above post's.