topic Re: Match Not working in QlikView

Match Not working

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to match a field with the selections made for that field but it's not working and i can't see what I am doing wrong.

The field is BGCompany which contains '[Acc - Superbia]'

The Selections for the field contains '[Acc - New Heights],[Acc - Superbia] ' using =GetFieldSelections(BGCompany,',',50)

The Match statement used is =Match(BGCompany,GetFieldSelections(BGCompany, ',',50)) which returns 0 where I am expecting something > 0.

I am sure that I am missing something very simple, please help.

vamsee — Fri, 05 Oct 2018 16:23:55 GMT

Hi George,

Try

If your looking for count

=SubField(GetFieldSelections(BGCompany,','), 'of',1)

If you are looking for values

=SubField(GetFieldSelections(BGCompany,',',50), 'of',1)

vishsaggi — Fri, 05 Oct 2018 16:25:05 GMT

may be try this?

= Substringcount(BGCompany, GetFieldSelections(BGCompany))

Anonymous — Sat, 06 Oct 2018 15:58:21 GMT

Thanks for the answers this worked I just had to reverse the order of the parameters

Substringcount( GetFieldSelections(BGCompany),BGCompany)

Happy Me