Set Analysis and Nulls

[brf10043]

In my data I have a source that only lists QIDs that are emergency items.  In my load script I've added the code below to add a column called Emergency_Flag and put a Yes in the column.

  'Yes' as Emergency_Flag

In the primary data source I also have QIDs that are not emergency items and do not have a column to flag them as not emergency.

The QID is the keythat holds the data together.

I'm have code to pull QIDs for the current month and Vulnerability is like Obsolete.  The code works fine.

=Only({<MonthName = {$(vCurrentMonth)},Vulnerability= {"=Vulnerability like '*EOL/Obsolete*'"}>} QID)

The question I have is how do I add Emergency_Flag is null to the set analysis above?

[sunny_talwar · Accepted solution]

May be this

=Only({<MonthName = {$(vCurrentMonth)}, Vulnerability = {"=Vulnerability like '*EOL/Obsolete*'"}, QID = {"=Len(Trim(Emergency_Flag)) = 0"}>} QID)

[brf10043]

Brilliant!  Worked perfectly.  Thanks Sunny

[Sergey_Shuklin]

Hello, Bobby!

If you've got right answer - please close the thread and mark Sunny's reply as correct or/and helpful.

Thank you!