Qliksense formatting question

[Aag]

Hello all,  I have started working recently in Qlik.. 

I have questions on formatting. 

a) In the filter pane - I see Year filter is always right justified. How can I change it to left justified. I explored all the options in presentation but could not find a way to left justify the filter options. How ever I could see option to left justify the field itself i.e. year but not those values. 

b) In pivot table I have Total column on the left most side and it is in bold. I want the totals column to appear rightmost and not bold. Or is there a way to bold the values of pivot table? 

Can someone please advise these questions. I am not sure how to resolve. Appreciate your help 

[Vegar · Accepted solution]

I'll give you an answer for question a. 

Qlik treats string and numerics differently in regard to alignment. Numerics are right aligned and strings are left aligned. This will in general make it easier to  read text and compare numerics.

A quick fix for making Year left align is therefore to present the value as a string. Try defining year like this in your script.

text(year(Date) ) as Year

Or using a calculated dimension in your app, like this

=text(Year) 

[PriyankaShivhare]

with the latest Sept 2020 version u can justify the text to left right or center as per your requirement

[Aag]

Awesome! Thanks so much for this tip. This worked. This is great solution!   

I am still trying to find out solution for  

 In pivot table I have Total column on the left most side and it is in bold. I want the totals column to appear rightmost and not bold. Or is there a way to bold the values of pivot table? 

Will close the thread once I get the response for this question.