Discussion Board for collaboration related to QlikView App Development.
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.
Many thanks as always.
Use "LIKE" keyword when using wildcards as follows
If(GetFieldSelections(VIEW) LIKE '*ear*', 'Found', 'Not Found')
This should work
View solution in original post
Yes, it works. Thanks.
I also found another solution:
=IF(SUBSTRINGCOUNT(GETFIELDSELECTIONS(View,''), 'Year-1') >0, 'Found', 'Not Found')