Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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

Re: Set Analysis Question

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

Re: Set Analysis Question

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

Re: Set Analysis Question

That did the trick!  Many Thanks

Highlighted
Creator
Creator

Re: Set Analysis Question

I have a follow up question

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

Highlighted

Re: Set Analysis Question

May be this:


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

Highlighted
Creator
Creator

Re: Set Analysis Question

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

Am I missing something?

Highlighted

Re: Set Analysis Question

Sorry, missed that part:

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

Highlighted
Creator
Creator

Re: Set Analysis Question

Yep, That did it