topic Set Analysis Question in QlikView

Set Analysis Question

brf10043 — Tue, 23 Feb 2016 19:38:01 GMT

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!

Re: Set Analysis Question

sunny_talwar — Tue, 23 Feb 2016 19:53:31 GMT

May be this if your first expression alone works:

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

Re: Set Analysis Question

brf10043 — Tue, 23 Feb 2016 22:36:13 GMT

That did the trick! Many Thanks

Re: Set Analysis Question

brf10043 — Tue, 23 Feb 2016 23:16:02 GMT

I have a follow up question

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

Re: Set Analysis Question

sunny_talwar — Tue, 23 Feb 2016 23:27:55 GMT

May be this:

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

Re: Set Analysis Question

brf10043 — Wed, 24 Feb 2016 00:03:51 GMT

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

Am I missing something?

Re: Set Analysis Question

sunny_talwar — Wed, 24 Feb 2016 00:51:04 GMT

Sorry, missed that part:

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

Re: Set Analysis Question

brf10043 — Wed, 24 Feb 2016 18:32:45 GMT

Yep, That did it