Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
davinfrost
Contributor III
Contributor III

qlik expression wrong?

hi guys, i want to know, why this become wrong?

thanks

1 Solution

Accepted Solutions
Rodj
Luminary Alumni
Luminary Alumni

Your expression will be failing because you can't define a set using "like". Instead you would have to use the advanced search syntax in a set modifier, so something like:

[Invoice No] = {"*BS*"}, // to replace the [Invoice No] like {'BS'},

View solution in original post

3 Replies
Rodj
Luminary Alumni
Luminary Alumni

Your expression will be failing because you can't define a set using "like". Instead you would have to use the advanced search syntax in a set modifier, so something like:

[Invoice No] = {"*BS*"}, // to replace the [Invoice No] like {'BS'},

davinfrost
Contributor III
Contributor III
Author

what is * in ' ', is that similiar with like or containing ?

Rodj
Luminary Alumni
Luminary Alumni

It's a wildcard basically, so with the double quotes it is effectively creating a search for a list of values that match BS with a wildcard either side. If your string is always going to start with BS you might just have "BS*" instead.