Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Sept. 16, Qlik Product Portfolio Strategy and Roadmap for Data Integration 11 AM ET REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jsimmonstx
Creator
Creator

Match problems

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?

12 Replies
mattquinnterex
Creator II
Creator II

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
MVP
MVP

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

View solution in original post

jsimmonstx
Creator
Creator
Author

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.