topic Re: If / and statements in QlikView https://community.qlik.com/t5/QlikView/If-and-statements/m-p/371926#M1171719 <HTML><HEAD></HEAD><BODY><P>Thanks! This worked great </P></BODY></HTML> Mon, 06 Aug 2012 09:39:13 GMT 2012-08-06T09:39:13Z If / and statements https://community.qlik.com/t5/QlikView/If-and-statements/m-p/371924#M1171717 <HTML><HEAD></HEAD><BODY><P>Hello, new to Qlikview and nearly finished my first project!</P><P></P><P>I am trying to work out how many helpdesk tickets we have had open since yesterday. In the database the open ticket is marked as "Scheduled" and I want to looked at tickets with a date other than todays...</P><P></P><P>My script at the moment looks like this..</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; if(Status='Scheduled',[Start Date]&lt;&gt;Today(),) As [Open Before Today] </P><P></P><P>The status works but not the start date.</P></BODY></HTML> Fri, 27 Jul 2012 14:52:32 GMT https://community.qlik.com/t5/QlikView/If-and-statements/m-p/371924#M1171717 2012-07-27T14:52:32Z Re: If / and statements https://community.qlik.com/t5/QlikView/If-and-statements/m-p/371925#M1171718 <HTML><HEAD></HEAD><BODY><P>if(Status='Scheduled' and [Start Date]&lt;&gt;Today(), 1, 0) As [Open Before Today]</P></BODY></HTML> Fri, 27 Jul 2012 14:54:23 GMT https://community.qlik.com/t5/QlikView/If-and-statements/m-p/371925#M1171718 swuehl 2012-07-27T14:54:23Z Re: If / and statements https://community.qlik.com/t5/QlikView/If-and-statements/m-p/371926#M1171719 <HTML><HEAD></HEAD><BODY><P>Thanks! This worked great </P></BODY></HTML> Mon, 06 Aug 2012 09:39:13 GMT https://community.qlik.com/t5/QlikView/If-and-statements/m-p/371926#M1171719 2012-08-06T09:39:13Z