Starts With / Begins With / Contains in QV - Qlik Community

Report Inappropriate Content · ‎2013-08-22

Hi all,

I'd like to add a filter to an expression that would exclude all items from a field that start with "Un".

I couldn't find the QV equivalent of starts with, or even contains.

Can the kind members of the community help me out ?

Thanks!

Gysbert_Wassenaar · ‎2013-08-22

You can use try the wildmatch function. For example in a calculated dimension: =if(wildmatch(MyField,'Un*', null(), MyField)

talk is cheap, supply exceeds demand

rustyfishbones · ‎2013-08-22

These videos may help also.

and

there are other videos there that contain similar answers

somenathroy · ‎2013-08-22

Use exclude function with set analysis as below:

sum({<name=E({<name={"Un*"}>}name)>}sales)

Regards,

Som