Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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
Partner - Creator III
Partner - Creator III

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
Partner - Creator III
Partner - Creator III

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
Partner - Creator III
Partner - Creator III

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.