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

Identify if a specific field value is in current selection

Tue, 20 May 2014 13:43:25 GMT

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.

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

anbu1984 — Tue, 20 May 2014 13:55:12 GMT

Try this

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

GetFieldSelections(fieldName) like '*value*'

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

Tue, 20 May 2014 13:55:59 GMT

would getCurrentSelections('FieldName') help you

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

lironbaram — Tue, 20 May 2014 14:09:17 GMT

have a look at the attach file

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

Tue, 20 May 2014 14:15:51 GMT

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