topic Re: Set Analysis and Nulls in QlikView

Set Analysis and Nulls

brf10043 — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Set Analysis and Nulls

sunny_talwar — Mon, 30 Oct 2017 23:17:44 GMT

May be this

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

Re: Set Analysis and Nulls

brf10043 — Tue, 31 Oct 2017 03:08:44 GMT

Brilliant! Worked perfectly. Thanks Sunny

Re: Set Analysis and Nulls

Sergey_Shuklin — Tue, 31 Oct 2017 04:50:32 GMT

Hello, Bobby!

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

Thank you!