Limit Values Shown in Filter Pane

[hlines_usacs]

Hello - I am using Qlik Sense and have a field that I want to filter on with similar values to those listed here.

NCLED

NCERE

NCNAH

92365

95362

93101

I would like only the values that start with "NC" to show in the filter pane to then filter on those. Is there a way to do this in Qlik Sense?

[sunny_talwar · Accepted solution]

May be like this

If(WildMatch(FilterField, 'NC*'), FilterField)

[hlines_usacs]

Perfect! Thanks!

[siddharthsoam]

Can you please tell where do we have to apply this expression?

[sunny_talwar]

It could be in the script or front end based on your requirement