Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Set Analysis Question

Hi all,  I'm attempting to combine the following two set analysis statements into a single expression.  I'm new to Set Analysis and am a bit stuck.

Essentially, I need a single expression that says only show the App Managed By column if the MonthName = vCurrentMonth and the Vulnerability is not null.

These work independently but I can't seem to combine them,

Only({<MonthName = {$(vCurrentMonth)}>}[App Managed By])

Only({<[Vulnerability] -= {'=(NULL())'} >} [App Managed By])

Any help is much appreciated!

1 Solution

Accepted Solutions
Highlighted

May be this if your first expression alone works:

Only({<MonthName = {$(vCurrentMonth)}, Vulnerability ={"=Len(Trim(Vulnerability)) > 0"} >}[App Managed By])

View solution in original post

7 Replies
Highlighted

May be this if your first expression alone works:

Only({<MonthName = {$(vCurrentMonth)}, Vulnerability ={"=Len(Trim(Vulnerability)) > 0"} >}[App Managed By])

View solution in original post

Highlighted
Creator
Creator

That did the trick!  Many Thanks

Highlighted
Creator
Creator

I have a follow up question

I now need to count the distinct QID if the MonthName = vCurrentMonth and Vulnerability is like '*Java*'

Highlighted

May be this:


Count(DISTINCT {<MonthName = {$(vCurrentMonth)}, Vulnerability ={"=Len(Trim(Vulnerability)) > 0"} >}QID)

Creator
Creator

I don't quit get this Vulnerability ={"=Len(Trim(Vulnerability)) > 0"}   I need for Vulnerability to be like *Java*

Am I missing something?

Highlighted

Sorry, missed that part:

Count(DISTINCT {<MonthName = {$(vCurrentMonth)}, Vulnerability ={'*Java*'} >}QID)

Highlighted
Creator
Creator

Yep, That did it