Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

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

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.

column1.PNG

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

column2.PNG

but I want values to be aligned right

1 Solution

Accepted Solutions
carlos_reyes_qv
Not applicable

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

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.

4 Replies
carlos_reyes_qv
Not applicable

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

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.

Not applicable

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

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

carlos_reyes_qv
Not applicable

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

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.

Not applicable

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

Thank you!!! I worked