Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

5 Replies
ogster1974
Partner - Master II
Partner - Master II

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
Not applicable
Author

Not applicable
Author

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

reddy-s
Master II
Master II

Hi Prasanta,

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

ogster1974
Partner - Master II
Partner - Master II

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.