topic Where/If statement in loading script in QlikView https://community.qlik.com/t5/QlikView/Where-If-statement-in-loading-script/m-p/161781#M35545 <HTML><HEAD></HEAD><BODY><P>Try using the following expression to ignore the sold quantity for 120 when it is less than 0:</P><P>=if([Sold Quantity]&lt;0 and Site =120,'',[Sold Quantity])</P></BODY></HTML> Mon, 16 Aug 2010 11:13:55 GMT 2010-08-16T11:13:55Z Where/If statement in loading script https://community.qlik.com/t5/QlikView/Where-If-statement-in-loading-script/m-p/161780#M35544 <HTML><HEAD></HEAD><BODY><P>Hey All,</P><P>I was sure this is an easy thing to do, but it's driving me crazy!! So, any help will be appreciated.</P><P>Basically, we have two sites, 110 and 120, and what I am trying to achieve is that if the sold qty is less than 0 for site 120, I don't want to show it! (I do for the ones in 110). I was thinking an if statement or a where clause in the loading script.. but nothing is really giving me the results!</P><P>Please help!</P><P>Kind Regards,<BR />Dayna</P></BODY></HTML> Mon, 16 Aug 2010 10:55:06 GMT https://community.qlik.com/t5/QlikView/Where-If-statement-in-loading-script/m-p/161780#M35544 Dayna 2010-08-16T10:55:06Z Where/If statement in loading script https://community.qlik.com/t5/QlikView/Where-If-statement-in-loading-script/m-p/161781#M35545 <HTML><HEAD></HEAD><BODY><P>Try using the following expression to ignore the sold quantity for 120 when it is less than 0:</P><P>=if([Sold Quantity]&lt;0 and Site =120,'',[Sold Quantity])</P></BODY></HTML> Mon, 16 Aug 2010 11:13:55 GMT https://community.qlik.com/t5/QlikView/Where-If-statement-in-loading-script/m-p/161781#M35545 2010-08-16T11:13:55Z Where/If statement in loading script https://community.qlik.com/t5/QlikView/Where-If-statement-in-loading-script/m-p/161782#M35546 <HTML><HEAD></HEAD><BODY><P>Perfect - many thanks!</P></BODY></HTML> Mon, 16 Aug 2010 12:24:01 GMT https://community.qlik.com/t5/QlikView/Where-If-statement-in-loading-script/m-p/161782#M35546 Dayna 2010-08-16T12:24:01Z