Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
hlines_usacs
Contributor II

Limit Values Shown in Filter Pane

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?

1 Solution

Accepted Solutions
MVP
MVP

Re: Limit Values Shown in Filter Pane

May be like this

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

4 Replies
MVP
MVP

Re: Limit Values Shown in Filter Pane

May be like this

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

hlines_usacs
Contributor II

Re: Limit Values Shown in Filter Pane

Perfect! Thanks!

siddharthsoam
Contributor

Re: Limit Values Shown in Filter Pane

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

MVP
MVP

Re: Limit Values Shown in Filter Pane

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