topic Set analysis problem in QlikView

Set analysis problem

Wed, 10 Aug 2011 11:01:10 GMT

Hi Everyone,

I am trying to count the number of projects completed before deadline using set analysis.

I am using the following code:

count ( { < Completion_Date = { " <= Deadline_Date " } > } ProjectID )

I am not getting the right result. Please help!

Regards

Arun

lironbaram — Wed, 10 Aug 2011 11:10:50 GMT

hei

in your case use

count (if(Completion_Date <= Deadline_Date , ProjectID ))

set analysis wont work as it get only one value in your case is null

set analysis is like making a selection so after the <= i try to calculate a value

but as there more then one value of Deadline Date it will get null

Wed, 10 Aug 2011 11:20:34 GMT

Thanks a lot.