topic Re: Like function in Current Selections in QlikView

Like function in Current Selections

Tue, 29 Apr 2014 10:34:33 GMT

Hi,

I'm looking for a way to check if a value 'X' is part of my selection.

for example if I select values: 1,2,3,4,5,6 my DATA field

I want to verify that the value '3 'is part of my selection

any idea?

Roop — Tue, 29 Apr 2014 10:43:20 GMT

Use:

FieldIndex('Data','X') and check that value returns is larger than zero

MK_QSL — Tue, 29 Apr 2014 10:57:51 GMT

Write below in Text Box

=IF(SubStringCount(Concat(YourFieldName, '|'), 'B'),'Yes','No')

If you select single or multiple values from your Field and if it contains B, you will get Yes otherwise No

anbu1984 — Tue, 29 Apr 2014 11:17:01 GMT

GetCurrentSelections(DATA) like '*,3,*'

Index(GetCurrentSelections(DATA),',3,')

Tue, 29 Apr 2014 11:23:30 GMT

what about the negation ? Not Like doesnt work.

anbu1984 — Tue, 29 Apr 2014 11:32:46 GMT

Not(GetCurrentSelections(DATA) like '*,3,*')