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

Window Title(Caption) in combo chart

Hi,

I have combo chart with title,along with title i want to display one-by-one field names.

Ex:- My title is Brand analysis and i have different fields like field1,field2,field3 in three different dimensions.

When i selecting one-by-one fields,I want output like this in caption,

Brand analysis-field1

Brand analysis-field1-field2

Brand analysis-field1-field2-field3

like this i want in caption..

any one having the idea about this.

Regards,

baru

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Try this:

='Brand Analysis '
&
if(not isnull(field1),'-'&field1)
& if(not isnull(field2),'-'&field2)
& if(not isnull(field3),'-'&field3)

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Try this:

='Brand Analysis '
&
if(not isnull(field1),'-'&field1)
& if(not isnull(field2),'-'&field2)
& if(not isnull(field3),'-'&field3)

IAMDV
Luminary Alumni
Luminary Alumni

Hi Baru,

You need to use something like this :

'Brand Analysis - ' & Concat(Distinct Subfield( GetCurrentSelections('==', '=='), '==', ValueLoop(1, 1000, 2)), ' - ')

This expression works on all the charts and irrespective of any dimension. However, you need to change the ValueLoop contents where I have used maximum value as 1000 but you can use any value based on your dataset.

Cheers,

DV

www.QlikShare.com

Not applicable
Author

Hi Phil & Deepak,

Thanks for your reply and solutions.

Regards,

baru