topic Re: Build a count function with two conditions in QlikView

Build a count function with two conditions

Wed, 19 Mar 2014 13:17:04 GMT

Hello ,

Can anybody can build an expression - function count names with two conditions :

first A - B > 0

second 'Is it subject'= Yes

Thanks

Re: Build a count function with two conditions

alexandros17 — Wed, 19 Mar 2014 13:21:18 GMT

The expression you are looking for is this:

Sum(If( Condition1 and Condition2, 1, 0)

is equivalemt to a count infact it sums 1 if both condition are satisfied

Hope it helps

Re: Build a count function with two conditions

Wed, 19 Mar 2014 13:32:52 GMT

Thanks Alessandro,

I assumed It will be

Sum( If ( A - B > 0 and [Is it subject]= {Yes}, 1, 0)

but I am a new community member and I don't know where to put a 'name' which will be summed

Re: Build a count function with two conditions

MK_QSL — Wed, 19 Mar 2014 13:38:23 GMT

Sum( If ( (A - B) > 0 and [Is it subject]= {'Yes'}, 1, 0)

Re: Build a count function with two conditions

alex_millan — Wed, 19 Mar 2014 13:39:55 GMT

If [Is it subject] is a field name and Yes is the value,

you can try to set the second condition as [Is it subject] = 'Yes'

so the final syntax would be:

Sum(If A-B >0 And [Is it subject] = 'Yes',1,0)

Good luck!

Re: Build a count function with two conditions

Wed, 19 Mar 2014 13:50:15 GMT

Thanks for answers ,

I build a functions but is error in expression and it no use .

Sum( If ( (-) > 0 and [Is it subject]= {'YES'}, 1, 0))

Could be an issue that A = one value + second and the same B (C+D)

Does anybody have any idea ?

Re: Build a count function with two conditions

alex_millan — Wed, 19 Mar 2014 15:00:28 GMT

Maybe I didn't understand you well.

A, B and [Is it subject] are fields, right?

If so, I think this expression should work:

Sum(If(A-B>0 AND [Is it subject] = 'YES', 1, 0))

Let's see it it works

Re: Build a count function with two conditions

Wed, 19 Mar 2014 15:06:01 GMT

Alex,

That's right A, B and [Is ... ] are fields

Your last answer was great !

Cheers M8