topic Re: Count if and expression in QlikView

Count if and expression

Tue, 26 May 2015 14:55:29 GMT

I am having trouble creating a count if and expression in my analysis.

I am looking to get the count if Field1 if Field2 = Yes, and Filed3 = 4

=Count(if(Field2='Yes',and(Field3=4))Field1)

swuehl — Tue, 26 May 2015 14:59:50 GMT

Maybe

=Count( if(Field2='Yes' and Field3=4 , Field1))

Anonymous — Tue, 26 May 2015 15:03:59 GMT

Hi,

Your expression is wrong.

Try this:

=Count(if(Field2='Yes' and Field3=4,Field1))

Tue, 26 May 2015 15:05:24 GMT

That worked.. thank you