topic Window Title(Caption) in combo chart in QlikView

Window Title(Caption) in combo chart

Wed, 16 May 2012 12:46:01 GMT

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

Re: Window Title(Caption) in combo chart

Anonymous — Wed, 16 May 2012 14:29:26 GMT

Try this:

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

Re: Window Title(Caption) in combo chart

IAMDV — Wed, 16 May 2012 15:41:05 GMT

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,

www.QlikShare.com

Window Title(Caption) in combo chart

Thu, 17 May 2012 10:00:44 GMT

Hi Phil & Deepak,

Thanks for your reply and solutions.

Regards,

baru