Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

getfieldselections with wildcard

Hi all,

Using the getfieldselections function how can I combine it with a wildcard? For example:

getfieldselections(VIEW) = 'Year-1'

so I need to use the wildcard to search the text string so that when more than one selection is made from VIEW, TRUE is returned providing Year-1 is one of the selections. I tried this:

getfieldselections(VIEW) = *'Year-1'* but it didn't work.

Any suggestions?

Many thanks as always.

1 Solution

Accepted Solutions
Highlighted

getfieldselections with wildcard

Hello,

Use "LIKE" keyword when using wildcards as follows

If(GetFieldSelections(VIEW) LIKE '*ear*', 'Found', 'Not Found')


This should work

View solution in original post

2 Replies
Highlighted

getfieldselections with wildcard

Hello,

Use "LIKE" keyword when using wildcards as follows

If(GetFieldSelections(VIEW) LIKE '*ear*', 'Found', 'Not Found')


This should work

View solution in original post

Highlighted
Not applicable

getfieldselections with wildcard

Yes, it works. Thanks.

I also found another solution:

=IF(SUBSTRINGCOUNT(GETFIELDSELECTIONS(View,''), 'Year-1') >0, 'Found', 'Not Found')

Many thanks.