Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

how to align columns in a qlik sense pivot table

hi,

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

Thanks

Prasanta

Tags (1)
5 Replies
ogster1974
Honored Contributor II

Re: how to align columns in a qlik sense pivot table

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

balrajahlawat
Esteemed Contributor

Re: how to align columns in a qlik sense pivot table

Not applicable

Re: how to align columns in a qlik sense pivot table

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

reddys310
Honored Contributor II

Re: how to align columns in a qlik sense pivot table

Hi Prasanta,

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

ogster1974
Honored Contributor II

Re: how to align columns in a qlik sense pivot table

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.

Community Browser