topic Re: Set Analysis in QlikView

Set Analysis

Thu, 17 Oct 2013 10:04:33 GMT

Hi All,

I have only recently started to use Set Analysis for simple selections. I am looking for a steer as to how to tackle a particular challenge.

Given the below data set, how do I could the number of Projects (using Project ID) that have 0 - 5 open risks, 5 - 10 open risks etc.

Many thanks,

Data Set

Projects ID	Risk ID	Status
P001	16	Open
P001	15	Open
P001	14	Open
P001	13	Open
P001	12	Open
P001	11	Closed
P007	10	Cancelled
P008	9	On Hold
P008	8	Open
P008	7	In Progress
P008	6	Cancelled
P008	156	Closed
P008	4	Open
P014	30	Proposed
P015	2	Cancelled
P016	1	In Progress
P017	100	Open
P018	1	On Hold

Desired Output

0 - 5 Open or On Hold Risks	5 - 10 Open or On Hold Risks	10 - 5 Open or On Hold Risks	etc
# of projects by Project ID

Re: Set Analysis

Gysbert_Wassenaar — Thu, 17 Oct 2013 10:16:36 GMT

See attached qvw

Re: Set Analysis

Kushal_Chawda — Thu, 17 Oct 2013 11:04:26 GMT

see the attached one

Re: Set Analysis

Thu, 17 Oct 2013 13:27:50 GMT

Thanks G Wassenaar & Kush141087 for your help with this. Much appreciated.

I have used the solution provided by G Wassenaar. Whilst it was slightly different to my original request it is the most elegant solution to my current challenge, however I will need to use both solutions further down the line.

Thanks again to both of you.