Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

somenathroy
Contributor III

Title of the Filter pane containing expression

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.

Capture.JPG

Is there any work around?

Regards,

som

6 Replies
rohitk1609
Valued Contributor II

Re: Title of the Filter pane containing expression

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
Honored Contributor III

Re: Title of the Filter pane containing expression

in loading table do like this

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


then you can District as filter

somenathroy
Contributor III

Re: Title of the Filter pane containing expression

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
Honored Contributor III

Re: Title of the Filter pane containing expression

Try Creating a Master Dimension with this concatenation.

Hopefully that will serve the purpose.

somenathroy
Contributor III

Re: Title of the Filter pane containing expression

Master dimension does not solve the problem.

rohitk1609
Valued Contributor II

Re: Title of the Filter pane containing expression

Hi Some,

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