Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Identify if a specific field value is in current selection

Hi,

I'm interested in creating a conditional for an expression that identifies whether or not a specific field value is selected, and if it is shows the expression in a line chart. I was able to use: fieldName = 'value', but that only works if the only value selected in that field is 'value'. However I would like this to work if there are multiple selections for that field, as long as 'value' is one of them. I had previously asked this question and was told to use WildMatch(concat(fieldName), '*value*'), but this is not working for some reason. Does anybody know how to solve this?


Thanks for all of the help.

1 Solution

Accepted Solutions
anbu1984
Honored Contributor III

Re: Identify if a specific field value is in current selection

Try this

WildMatch(GetFieldSelections(fieldName),'*value*')

Or

GetFieldSelections(fieldName) like '*value*'

4 Replies
anbu1984
Honored Contributor III

Re: Identify if a specific field value is in current selection

Try this

WildMatch(GetFieldSelections(fieldName),'*value*')

Or

GetFieldSelections(fieldName) like '*value*'

Not applicable

Re: Identify if a specific field value is in current selection

would getCurrentSelections('FieldName') help you

lironbaram
Honored Contributor II

Re: Identify if a specific field value is in current selection

hi

have a look  at the attach file

Not applicable

Re: Identify if a specific field value is in current selection

GetFieldSelections(fieldName) like '*value*' works perfectly. Thanks.