Set Analysis Question

[brf10043]

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!

[sunny_talwar · Accepted solution]

May be this if your first expression alone works:

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

[brf10043]

That did the trick!  Many Thanks

[brf10043]

I have a follow up question

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

[sunny_talwar]

May be this:

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

[brf10043]

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

Am I missing something?

[sunny_talwar]

Sorry, missed that part:

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

[brf10043]

Yep, That did it