Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

stefan_fischer
New Contributor II

Format Total

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

1 Solution

Accepted Solutions
stigchel
Honored Contributor

Re: Format Total

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

10 Replies
maleksafa
Valued Contributor

Re: Format Total

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

fvelascog72
Valued Contributor

Re: Format Total

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
Honored Contributor II

Re: Format Total

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

stefan_fischer
New Contributor II

Re: Format Total

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

stigchel
Honored Contributor

Re: Format Total

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

awhitfield
Esteemed Contributor

Re: Format Total

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
Honored Contributor II

Re: Format Total

apply the above technique.

buzzy996
Honored Contributor II

Re: Format Total

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

stefan_fischer
New Contributor II

Re: Format Total

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

Community Browser