Starts With / Begins With / Contains in QV

[#1]

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]

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

[rustyfishbones]

These videos may help also.

Qlikview IF & WILDMATCH RFB 128 - YouTube

and

Qlikview PICK + WILDMATCH by RFB 129 - YouTube

there are other videos there that contain similar answers

[somenathroy]

Use exclude function with set analysis as below:

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

Regards,

Som