topic All fields {1} and IF statment in QlikView https://community.qlik.com/t5/QlikView/All-fields-1-and-IF-statment/m-p/172871#M42274 <HTML><HEAD></HEAD><BODY><P>Hi There,</P><P>I need an IF statement to ignore current selections and to check all fields, I've done this with a number of aggregate functions using {1} but having some problems getting it to work in this scenario, Could someone point me in the right direction?</P><P>=IF(UserID=21 AND Closed=0 ,CompanyName,Null())</P></BODY></HTML> Tue, 09 Mar 2010 15:29:03 GMT 2010-03-09T15:29:03Z All fields {1} and IF statment https://community.qlik.com/t5/QlikView/All-fields-1-and-IF-statment/m-p/172871#M42274 <HTML><HEAD></HEAD><BODY><P>Hi There,</P><P>I need an IF statement to ignore current selections and to check all fields, I've done this with a number of aggregate functions using {1} but having some problems getting it to work in this scenario, Could someone point me in the right direction?</P><P>=IF(UserID=21 AND Closed=0 ,CompanyName,Null())</P></BODY></HTML> Tue, 09 Mar 2010 15:29:03 GMT https://community.qlik.com/t5/QlikView/All-fields-1-and-IF-statment/m-p/172871#M42274 2010-03-09T15:29:03Z