Discussion Board for collaboration related to QlikView App Development.
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 ?
You can use try the wildmatch function. For example in a calculated dimension: =if(wildmatch(MyField,'Un*', null(), MyField)
These videos may help also.
Qlikview IF & WILDMATCH RFB 128 - YouTube
Qlikview PICK + WILDMATCH by RFB 129 - YouTube
there are other videos there that contain similar answers
Use exclude function with set analysis as below: