Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
That worked!! Thank you as always Sunny!!!
May be like this in set analysis
{<Units -= {'Unit1', 'Units2', .... and so on}>}
Hey Sunny,
Thank you! But when I do that {<Unit -= {'sccc', 'sicu'}>}, it says there is an error in expression.
What is the whole expression you are using?
See below, it's just "Unit" since I'm bringing it in via API that's what the field is called.
Try this as calculated dimension:
If(Not Match(Unit, 'sccc', 'sicu'), Unit)
and keep 'Show Null Values' unchecked
Refer thsee threads on Set Analysis
Set Analysis: syntaxes, examples
https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/
Hi Elizabeth,
What QlikView version are you using?
That worked!! Thank you as always Sunny!!!
Thanks Vineeth.