how to align columns in a qlik sense pivot table

[#1]

hi,

Please advise how to align text in columns of a pivot table (Please refer the attachment).

Thanks

Prasanta

[ogster1974]

Qlik Sense doesn't have user defined formatting options at the moment due to its focus on the responsive layout.  As you have mixed values in your table Sense is formatting on the type of value displayed in the cell.  % right aligned and your other value type is probably being interpreted as text so left aligned.

I'd separate the values into different tables or columns as it looks like you are showing 2 different values in the same table column.

Regards

Andy

[Anonymous]

Did you check this?

How to align straight table column values in qlik sense

Tables in Qlik Sense

[#4]

thanks, i have left aligned them using Text().

[reddy-s]

Hi Prasanta,

Thats the only way to align values as of now. By using the text() or num() functions.

[ogster1974]

Please note formatting the data this way will effect what is exported to excel.  So double check that is acceptable before you commit to it.