Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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.