Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be this
=Only({<MonthName = {$(vCurrentMonth)}, Vulnerability = {"=Vulnerability like '*EOL/Obsolete*'"}, QID = {"=Len(Trim(Emergency_Flag)) = 0"}>} QID)
May be this
=Only({<MonthName = {$(vCurrentMonth)}, Vulnerability = {"=Vulnerability like '*EOL/Obsolete*'"}, QID = {"=Len(Trim(Emergency_Flag)) = 0"}>} QID)
Brilliant! Worked perfectly. Thanks Sunny
Hello, Bobby!
If you've got right answer - please close the thread and mark Sunny's reply as correct or/and helpful.
Thank you!