Set Analysis, Multiple Conditions

[#1]

Hi

I need to count the number of Task_ID_New based on the following conditions:

Completion_Date is less than or equal to Due_Date

Source = Assignments or (Source=Tasks and TASK_TYPE = Product).

I can do get the correct results of Assignments by itself and Tasks by itself but cannot seem to combine them into one chart.

Assume I can use set analysis but have not been able to get the correct results.

Attached is a sample showing all the data in a Table Box and then two separate staight tables.

Want the reuslts of the two combined into one straight table.

Thanks in advance for any and all help.

[#2 · Accepted solution]

Hi ,

try the below expression

count(if((

Source='Tasks' and TASK_TYPE='Product' and Completion_Date<=Due_Date)

or

(Source='Assignments'and Completion_Date<=Due_Date),Task_ID_New))

[#3]

Hi,

try this

=

Count(if((Source ='Assignments' Or (Source='Tasks' and TASK_TYPE = 'Product')) and (Completion_Date <= Due_Date),Task_ID_New))

Niranjan M.

[#4]

Hi,

try this

=

if(Completion_Date <= Due_Date),Count({<Source ={'Assignments','Tasks' }, TASK_TYPE ={ 'Product'}>}Task_ID_New) )

Hope it helps you!!...

Cheers,

Chandra

[#5]

hi

see this link

http://community.qlik.com/message/136125

http://community.qlik.com/message/283514

http://community.qlik.com/message/266912

or try it.

IF(Completion_Date <= Due_Date),Count({<Source ={'Assignments','Tasks' }, TASK_TYPE ={ 'Product'}>}Task_ID_New) )

hope it help you.

[Gysbert_Wassenaar]

Try:

Count(if(Completion_Date <= Due_Date

            and (Source = 'Assignments'

            or (Source = 'Tasks' and TASK_TYPE = 'Product')),

            Task_ID_New))

If you add a unique ID field to your table (i.e. rowno() as ID) you can use a set analysis expression:

count({<Source={'Assignments'},ID={"=Completion_Date<=Due_Date"}>+<Source={'Tasks'},TASK_TYPE={'Product'},ID={"=Completion_Date<=Due_Date"}>} Task_ID_New)

[#7]

Thanks everyone for your help!