Solved: Chart Title Change if Any filed selected - Qlik Community

deniscamh · ‎2017-08-18

Hi All,

Is there a way in Qlik Sense to change Chart Title if any field (not specific) on the sheet selected?

For example I have chart with title "Total Revenue" when no selection made, as soon as user makes any selection the title changes to

"Partial Revenue".

Thanks

Denis

Anonymous · ‎2017-08-18

You certainly can by putting in a suitable expression.

I expect you will need to use the GetCurrentSelections() function, here is the url to the Help for it :

It there are no selections then it will return nothing and have a length of zero that you could use in an if statement using :

len(getcurrentselections())

So you maybe need something like :

= if ( len(getcurrentselections()) = 0 , 'Total Revenue' , 'Partial Revenue' )

Anonymous · ‎2017-08-18

You certainly can by putting in a suitable expression.

I expect you will need to use the GetCurrentSelections() function, here is the url to the Help for it :

It there are no selections then it will return nothing and have a length of zero that you could use in an if statement using :

len(getcurrentselections())

So you maybe need something like :

= if ( len(getcurrentselections()) = 0 , 'Total Revenue' , 'Partial Revenue' )

deniscamh · ‎2017-08-18

Thanks Bill,

The len function is a key here, great suggestion.

I tried this function without Len and it did not work.

Thank you for URL as well.