Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be this if your first expression alone works:
Only({<MonthName = {$(vCurrentMonth)}, Vulnerability ={"=Len(Trim(Vulnerability)) > 0"} >}[App Managed By])
May be this if your first expression alone works:
Only({<MonthName = {$(vCurrentMonth)}, Vulnerability ={"=Len(Trim(Vulnerability)) > 0"} >}[App Managed By])
That did the trick! Many Thanks
I have a follow up question
I now need to count the distinct QID if the MonthName = vCurrentMonth and Vulnerability is like '*Java*'
May be this:
Count(DISTINCT {<MonthName = {$(vCurrentMonth)}, Vulnerability ={"=Len(Trim(Vulnerability)) > 0"} >}QID)
I don't quit get this Vulnerability ={"=Len(Trim(Vulnerability)) > 0"} I need for Vulnerability to be like *Java*
Am I missing something?
Sorry, missed that part:
Count(DISTINCT {<MonthName = {$(vCurrentMonth)}, Vulnerability ={'*Java*'} >}QID)
Yep, That did it