Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

paisleymike
New Contributor III

Change Title by filters

Hello

Is there a  way to make a dynamic title/text so that depending on what is selected by the filter changes to title

i.e.

If A is selected in the filter, change the title to "Show A", if B is selected in the filter change title to "Show B"

Thank you

5 Replies
erik_wetterberg
Honored Contributor

Re: Change Title by filters

Hi,

You could use GetFieldSelections in a dynamic title.

Erik Wetterberg

Erik Wetterberg
https://extendingqlik.upper88.com/
OmarBenSalem
Esteemed Contributor

Re: Change Title by filters

Sure:

You can do sthing like this:

if(len(getfieldSelections(YourDimension))=0,'Show all', 'show '&concat(YourDimension,', ') )

hacr-sds
Contributor

Re: Change Title by filters

Make a variable in your load-script:

SET vField = GetFieldSelections(filter-field);

Set your title as "=$(vField)" and you are good to go

vanand3535
Contributor

Re: Change Title by filters

Yes, you can do it by following,

try this as I mentioned below:-

Expression syntax:

Titles:- 

='Sales Per Year'  & GetFieldSelections(Year)

SubTitles:-

='Total no: of Sales' & sum(Sales)

Footer Syntax:-

='Total products sold per year' & Count(ProductName)

Screenshot (596).png

vanand3535
Contributor

Re: Change Title by filters

After selecting the year title will change as below:-

Screenshot (598).png

without selection, title will remain as it is:-

Screenshot (600).png

Community Browser