Window Title(Caption) in combo chart

[#1]

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

[Anonymous · Accepted solution]

Try this:

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

[IAMDV]

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

[#4]

Hi Phil & Deepak,

Thanks for your reply and solutions.

Regards,

baru