Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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.