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

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. 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

Labels (1)
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.