Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

deniscamh
Contributor

Chart Title Change if Any filed selected

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

1 Solution

Accepted Solutions

Re: Chart Title Change if Any filed selected

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 :

https://help.qlik.com/en-US/sense/June2017/Subsystems/Hub/Content/ChartFunctions/FieldFunctions/getc...

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' )

2 Replies

Re: Chart Title Change if Any filed selected

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 :

https://help.qlik.com/en-US/sense/June2017/Subsystems/Hub/Content/ChartFunctions/FieldFunctions/getc...

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
Contributor

Re: Chart Title Change if Any filed selected

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.

Community Browser