how to attach a subtitle for each title of columns?

[sdtfll]

In sheet of chart, currently only one title in main language for each column,

customer need another language as subtitle shown below the title,

how to  do it? 

I don't find such area to put .

[Andrei_Cusnir]

Hello @sdtfll,

Can you please share some additional details? Perhaps a screenshot of where the "subtitle" will go?

Because you have mentioned sheet and chart and I am not sure if you are looking for a way to add 2 lines in the title of a chart/sheet or if you want to add this within the columns of a Table chart etc. Some additional info and especially a screenshot, might help us get a better understanding. 

[sdtfll]

for example as this picture, I want a subtitle shown in another language.

[Andrei_Cusnir · Accepted solution]

Hello,

Thanks for the clarification! You can use the Chr(10) function, in combination with the two different languages directly in each dimension's Label expression. For example I have used the following expressions in the 3 dimensions' Label section:

• ='Capital' & Chr(10) & 'Κεφαλαία'
• ='Cars' & Chr(10) & 'Αυτοκίνητα'
• ='Houses' & Chr(10) & 'Σπίτια'

These are the results:

As you can see the first row is in English and the second is in Greek. I believe this is as close as you can get to your use case scenario natively in Qlik Sense. 

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members. 
 

[sdtfll]

thanks so much, it really helps,