Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
jack
Contributor III
Contributor III

Change caption in title text of chart based on variable values

In chart is based on value of   key  with a value   B','K','X','I'   in dimensions 

B stands for bread orders, K stands for Kilo orders,  X stands for Frozen orders, I stands for Import orders

Would be fine if caption changes by one pick or a mix of more picks

Like this sample if 2 are  active 

Labels (1)
2 Solutions

Accepted Solutions
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Have you try with the equal sign ?

Like :

 ='My title ' & Concat(distinct [Website], ', ')

Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

jack
Contributor III
Contributor III
Author

That worked,  thanks a lot 

Best regards Jack

View solution in original post

4 Replies
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

 

Have you try a expression like :  Concat(distinct [Website type], ', ')

 

Aurélien

 

Help users find answers! Don't forget to mark a solution that worked for you!
jack
Contributor III
Contributor III
Author

Hello ,   tried that one,  just did show me  exactly  " Concat(distinct [Website type], ', ')""

even after change to real field name  Concat(distinct [Website], ', ')

 

Then i tried this , but that only works ok is one click is active,  thus could you suggest how to

modify it so it will  concanate alle clicks ?

below will only work with one active click

=if(IsNull(Website),'All  Products ',' Sales for: '&Website)

Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Have you try with the equal sign ?

Like :

 ='My title ' & Concat(distinct [Website], ', ')

Help users find answers! Don't forget to mark a solution that worked for you!
jack
Contributor III
Contributor III
Author

That worked,  thanks a lot 

Best regards Jack