topic Re: qlik expression wrong? in QlikView

qlik expression wrong?

davinfrost — Wed, 25 Nov 2020 16:16:04 GMT

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

thanks

Re: qlik expression wrong?

Rodj — Tue, 18 Feb 2020 03:43:46 GMT

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'},

Re: qlik expression wrong?

davinfrost — Tue, 18 Feb 2020 03:58:33 GMT

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

Re: qlik expression wrong?

Rodj — Tue, 18 Feb 2020 04:39:12 GMT

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.