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

Announcements
Join us in Bucharest on Sept 18th 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.