Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
philbishop
Contributor

Re: Window Title(Caption) in combo chart

Try this:

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

3 Replies
philbishop
Contributor

Re: Window Title(Caption) in combo chart

Try this:

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

IAMDV
Honored Contributor II

Re: Window Title(Caption) in combo chart

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

Window Title(Caption) in combo chart

Hi Phil & Deepak,

Thanks for your reply and solutions.

Regards,

baru

Community Browser