Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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
Partner
Partner

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.

View solution in original post

4 Replies
Partner
Partner

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

Partner
Partner

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.

View solution in original post

Not applicable

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

Thank you!!! I worked