Match problems

[Anonymous]

I have a one-record table with the following column:

AppAbbrevs

which is a string that contains the following:

'Field1,Field2,Field3'

When I try MATCH('Field3', ',', AppAbbrevs), it returns 0. It also returns 0 if I surround each value with single quotes.

What am I doing wrong?

[Anonymous]

Ok John I have the solution!

Stick this in your data load editor

Strings:

LOAD

RowNo() as row,

Subfield(AppAbbrevs,',') as SingleStrings

Resident YOUR_TABLE_NAME_HERE_JOHN;

Then in your visualizations do:

if(SingleStrings = 'Field3', row)

That will do it

[tresesco · Accepted solution]

A front-end solution could be like:

=SubStringCount( Left( 'Field1,Field2,Field3', Index('Field1,Field2,Field3' , 'Field3')), ',')+1

Orange - Your field value string

Blue - Search string

Pink - Delimiter

[Anonymous]

Wow. That gives me the result I want, but it's more complicated than it should be...

It's this kind of thing that completely negates what makes qlikview a decent tool.

In any case, many thanks.