topic How to (syntax) for a Count(if(List='one',List2='blue', items)) in QlikView https://community.qlik.com/t5/QlikView/How-to-syntax-for-a-Count-if-List-one-List2-blue-items/m-p/181539#M47520 <HTML><HEAD></HEAD><BODY><P>I´m trying to make a count with 2 criteria that needs to be true, - but the above does´nt work</P></BODY></HTML> Mon, 24 Jan 2011 12:33:34 GMT 2011-01-24T12:33:34Z How to (syntax) for a Count(if(List='one',List2='blue', items)) https://community.qlik.com/t5/QlikView/How-to-syntax-for-a-Count-if-List-one-List2-blue-items/m-p/181539#M47520 <HTML><HEAD></HEAD><BODY><P>I´m trying to make a count with 2 criteria that needs to be true, - but the above does´nt work</P></BODY></HTML> Mon, 24 Jan 2011 12:33:34 GMT https://community.qlik.com/t5/QlikView/How-to-syntax-for-a-Count-if-List-one-List2-blue-items/m-p/181539#M47520 2011-01-24T12:33:34Z How to (syntax) for a Count(if(List='one',List2='blue', items)) https://community.qlik.com/t5/QlikView/How-to-syntax-for-a-Count-if-List-one-List2-blue-items/m-p/181540#M47521 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>try out using the and condition as it will definately help solving your problem.</P></BODY></HTML> Mon, 24 Jan 2011 12:38:07 GMT https://community.qlik.com/t5/QlikView/How-to-syntax-for-a-Count-if-List-one-List2-blue-items/m-p/181540#M47521 gauravkhare 2011-01-24T12:38:07Z How to (syntax) for a Count(if(List='one',List2='blue', items)) https://community.qlik.com/t5/QlikView/How-to-syntax-for-a-Count-if-List-one-List2-blue-items/m-p/181541#M47522 <HTML><HEAD></HEAD><BODY><P>Found solution just use AND instead of the comma between the 2 criteria</P></BODY></HTML> Mon, 24 Jan 2011 12:39:14 GMT https://community.qlik.com/t5/QlikView/How-to-syntax-for-a-Count-if-List-one-List2-blue-items/m-p/181541#M47522 2011-01-24T12:39:14Z How to (syntax) for a Count(if(List='one',List2='blue', items)) https://community.qlik.com/t5/QlikView/How-to-syntax-for-a-Count-if-List-one-List2-blue-items/m-p/181542#M47523 <HTML><HEAD></HEAD><BODY><P>Thanx Gaurav <IMG alt="Big Smile" src="http://community.qlik.com/emoticons/emotion-2.gif" /></P></BODY></HTML> Mon, 24 Jan 2011 12:40:21 GMT https://community.qlik.com/t5/QlikView/How-to-syntax-for-a-Count-if-List-one-List2-blue-items/m-p/181542#M47523 2011-01-24T12:40:21Z How to (syntax) for a Count(if(List='one',List2='blue', items)) https://community.qlik.com/t5/QlikView/How-to-syntax-for-a-Count-if-List-one-List2-blue-items/m-p/181543#M47524 <HTML><HEAD></HEAD><BODY><P>hei there</P><P>1. count(if(List='one' and List2='blue',items))</P></BODY></HTML> Mon, 24 Jan 2011 12:40:43 GMT https://community.qlik.com/t5/QlikView/How-to-syntax-for-a-Count-if-List-one-List2-blue-items/m-p/181543#M47524 lironbaram 2011-01-24T12:40:43Z