Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Set Analysis and Nulls

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?

1 Solution

Accepted Solutions
Highlighted

May be this

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

View solution in original post

3 Replies
Highlighted

May be this

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

View solution in original post

Highlighted
Creator
Creator

Brilliant!  Worked perfectly.  Thanks Sunny

Highlighted
Specialist
Specialist

Hello, Bobby!

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

Thank you!