topic Mutliple Filter Values NOT Displaying in Dynamic Title in QlikView

Mutliple Filter Values NOT Displaying in Dynamic Title

Tue, 15 Apr 2014 23:12:06 GMT

Hi there,

I am familiar with creating a Chart Title that contains a filter (variable) value that will dynamically change the title to include the Filter value.

How do I display the values of the filter if there is more than one filter value selected though? Using the standard method, the filter values don't display at all in the title when there are multiple filter values selected. It works fine though when only one filter value is selected.

For example:

Filter Box: FinancialYear

2011
2012
2013

Chart Title: ='This is the Financial Report for: ' & FinancialYear

If I select 2011 (or 2012 or 2013) then the Chart Title looks fine as: This is the Financial Report for: 2011

If however, I select 2011 and 2012, then the Chart Title looks like this: This is the Financial Report for:

How can I display both 2011 and 2012 when they are both selected?

I know someone out there can help, and I thank you in advance!

Re: Mutliple Filter Values NOT Displaying in Dynamic Title

Tue, 15 Apr 2014 23:26:08 GMT

Hi Rene,

you may use expression like this:

=' This is the Financial Report for: '&Concat(F_year,',',F_year)

You my also use GetFieldSelections()...

I prepared example:)

Re: Mutliple Filter Values NOT Displaying in Dynamic Title

Tue, 15 Apr 2014 23:31:33 GMT

Thank you SO MUCH Darius!

It works like a charm, using get GetFieldSelections()

I really should have thought of that!

... And the Concat works even better! Especially when you have an OnActivate Sheet trigger. In such a case, the Concat gives a cleaner result in the title.

Thanks again!!

Re: Mutliple Filter Values NOT Displaying in Dynamic Title

Tue, 15 Apr 2014 23:57:16 GMT

Hi all,

This may be of use to someone (hoping)

I have also now found GetFieldSelections(FinancialYear) which alleviates duplicates that can occur when using Concat.

GetCurrentSelections might give too much information in some cases.