[Qlik Sense] how to right align text inside pivot table??

[#1]

I'm using a pivot table in qlik sense and want to align the money column to the right but there's no text-align option different from 'Table' chart.

Since my columns' values have different currency, so their alignment is different.

so I made it as a text to have the same alignment.

but I want values to be aligned right

[Carlos_Reyes]

Hi,

You can use the PurgeChar() funtion in the script or in the front end to get rid of the currency character. I think that's the one affecting some rows and Sense is not able to recognize those values as numeric values.

I think something like

Purgechar(Money,'$€')

or

Sum(Purgechar(Money,'$€'))

should work. Review the enclosed qvf file.

[#3]

I need a currency character... because there are several kinds of currencies I need to distinguish each other

[Carlos_Reyes · Accepted solution]

Ok, then you can use the dual function and/or take the currency sign to another field.

LOAD *

  ,Dual(Money,Num(PurgeChar(Money,'$€'))) as Final_Money

    ,Left(Money,1) as Currency_Sign

;

LOAD * Inline [

Row, Money

1, €250

2, $2300

3, €1720

4, $800

];

Review the enclosed file.

[#5]

Thank you!!! I worked