topic getfieldselections with wildcard in QlikView

getfieldselections with wildcard

Thu, 15 Jul 2010 10:49:11 GMT

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.

getfieldselections with wildcard

Miguel_Angel_Baeyens — Thu, 15 Jul 2010 12:19:58 GMT

Hello,

Use "LIKE" keyword when using wildcards as follows

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

This should work

getfieldselections with wildcard

Thu, 15 Jul 2010 14:52:58 GMT

Yes, it works. Thanks.

I also found another solution:

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

Many thanks.