topic Double Set Analysis in QlikView

Double Set Analysis

Anonymous — Mon, 11 Jan 2016 15:04:48 GMT

Hi All

Trying to do the following but cannot get to work.....Please help!

=count(DISTINCT{$<Assignee = {'Adil Hussain'}>}IssueID) and count(DISTINCT{<%StatusID = ('10116,10117,10118')

Thanks Alot

sunny_talwar — Mon, 11 Jan 2016 15:07:28 GMT

Try this may be:

For meeting both the conditions

=Count(DISTINCT{$<Assignee = {'Adil Hussain'}, %StatusID = {'10116', '10117', '10118'}>} IssueID)

For meeting one of the condition (either or), try this:

=Count(DISTINCT{$<Assignee = {'Adil Hussain'}>+<%StatusID = {'10116', '10117', '10118'}>} IssueID)

UPDATE: Keep an eye for the red things in the expression

Anonymous — Mon, 11 Jan 2016 15:15:00 GMT

You;re on a role Sunny!!!

thanks again

Correct 2 out of 2

Thanks for Advice as well, always appreciated

sunny_talwar — Mon, 11 Jan 2016 15:16:28 GMT

Not a problem. I am glad I am able to help