Excluding values in expressions

[hammermill21]

Hello!

I have a list of units I am pulling in but there are a few I want to exclude form a statement. How would I do that? Currently, I have a dimension called Unit which brings in 17 different units. I guess I need to know what to include in that expression to be able to exclude some of the units.

Thanks!

[sunny_talwar]

May be like this in set analysis

{<Units -= {'Unit1', 'Units2', .... and so on}>}

[hammermill21]

Hey Sunny,

Thank you! But when I do that {<Unit -= {'sccc', 'sicu'}>}, it says there is an error in expression.

[sunny_talwar]

What is the whole expression you are using?

[hammermill21]

See below, it's just "Unit" since I'm bringing it in via API that's what the field is called.

[sunny_talwar]

Try this as calculated dimension:

If(Not Match(Unit, 'sccc', 'sicu'), Unit)

and keep 'Show Null Values' unchecked

[vinieme12]

Refer thsee threads on Set Analysis

Set Analysis: syntaxes, examples

https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/

[#8]

Hi Elizabeth,

What QlikView version are you using?

[hammermill21 · Accepted solution]

That worked!! Thank you as always Sunny!!!

[hammermill21]

Thanks Vineeth.