Title of the Filter pane containing expression

[somenathroy]

Hi All,

In a Qlik Sense app. have prepared a filter pane with the concatenation of two fields as  [State ID] & ' - ' & [District Name]. Set Title by the text 'District' .  So when a value is being selected from the filter pane, the title of the selected value should be District instead of concatenated expression. Please refer the below screen shot.

Is there any work around?

Regards,

som

[rohitk1609]

Hi Some,

Yes this is the property of Qlik Sense when you create a calculated field and use it as in filter it will show like this.What you need to do ,Use this expression is Script editor and make a new filed District and then use this District here in filter pane. It will be as you want.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Rohit Kumar

[arulsettu]

in loading table do like this

[State ID] & ' - ' & [District Name] as District

then you can District as filter

[somenathroy]

Keeping these fields separated in data model and concatenating them in UI has a better memory utilization approach. Please refer Reducing the Size of a Data Model‌

Is there any way of doing this in UI ?

Thanks.

[shraddha_g]

Try Creating a Master Dimension with this concatenation.

Hopefully that will serve the purpose.

[somenathroy]

Master dimension does not solve the problem.

[rohitk1609]

Hi Some,

Create a new filed at the back-end and use it in the filter.