Dynamic title based on Filters and selections

[mskusace]

I have 4 filters at the top of my Qlik Sense dashboard that are in a hierarchy.

Continent -> Country -> State -> City

I have a 4 text box fields I created at the top which use the GetFieldSelections to display the filter selected. I can't get all the text boxes to update based on the various ways users can filter the data.

My desired results:

The left hand column is the filter applied and the other 4 columns are what should be displayed in the text box.

No Filter	Continent: All Continents	Country: All Countries	State: All States	City: All Cities
City Filter is Brooklyn	Continent: North America	Country: United States	State: New York	City: Brooklyn
State Filter is Texas	Continent: North America	Country: United States	State: Texas	City: All Cities
Country Filter is United States	Continent: North America	Country: United States	State: All States	City: All Cities
State Filter is California and Ohio	Continent: North America	Country: United States	State: California, Ohio	City: All Cities

*The full answer for my implementation is on my last post in this thread. Thanks to @Shubham_Deshmukh for the assistance!

[Shubham_Deshmukh]

As Qlikview works on associative model functionality, if you have continent along with country, states etc.

You just need to use below expression that field like this in text boxes : 

='Continent : '& continent

='Country : '& country

//continent & country are database field

When you will select city from filter, automatically value will get appear in text box

Regards,

Shubham

[mskusace]

When I try that in Qlik Sense, if I select 2 cities, it does not list anything for the States. If I select 1 city, it will list the proper state. It's the multiple selections that don't seem to work properly with that.

One thing to note is that there is only 1 table in my dashboard since all my data processing occurs outside of Qlik Sense. Therefore all the data is on this one table.

[Shubham_Deshmukh · Accepted solution]

Try this now: 

=If(RangeMax(GetSelectedCount(city), GetSelectedCount(city)) > 0, Concat(DISTINCT continent, ', '))

Regards

[mskusace]

That one works much better! 

I am running into one more issue now. I want this to apply to all the fields. 

I changed your code slightly to be:

=If(RangeMax(GetSelectedCount(city), GetSelectedCount(city)) > 0, Concat(DISTINCT city, ', ')) 

If a user selects a City or multiple cities, then all the selected Cities and associated States, Countries, Continents should show.

If a user selects a State or multiple states, then all the selected States and associated Cities, Countries, Continents should show.

If a user selects a Country or multiple countries, then all the selected Countries and associated Cities, States, and Continents should show.

If a user selects a Continent or multiple Continents, then all the selected Continents and associated Cities, States, and Countries should show or at least something saying "Multiple Selections" for Cities and States.

I hope that makes sense. 

[mskusace]

I got it! Thank you so much! 

Country: If(RangeMax(GetSelectedCount(City),GetSelectedCount(State), GetSelectedCount(Continent))>0,Concat(DISTINCT Country,', '))

State: If(RangeMax(GetSelectedCount(City),GetSelectedCount(Country), GetSelectedCount(Continent))>0,Concat(DISTINCT State,', '))

City: State: If(RangeMax(GetSelectedCount(State),GetSelectedCount(Country), GetSelectedCount(Continent))>0,Concat(DISTINCT City,', '))