topic Subtract minutes in QlikView https://community.qlik.com/t5/QlikView/Subtract-minutes/m-p/461208#M172180 <HTML><HEAD></HEAD><BODY><P>How can I subtract 1 minute from now() ? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 21 Dec 2012 14:57:33 GMT farolito20 2012-12-21T14:57:33Z Subtract minutes https://community.qlik.com/t5/QlikView/Subtract-minutes/m-p/461208#M172180 <HTML><HEAD></HEAD><BODY><P>How can I subtract 1 minute from now() ? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 21 Dec 2012 14:57:33 GMT https://community.qlik.com/t5/QlikView/Subtract-minutes/m-p/461208#M172180 farolito20 2012-12-21T14:57:33Z Re: Subtract minutes https://community.qlik.com/t5/QlikView/Subtract-minutes/m-p/461209#M172181 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>=timestamp(now()-1/1440)</P><P></P><P>Hope it helps</P></BODY></HTML> Fri, 21 Dec 2012 15:03:52 GMT https://community.qlik.com/t5/QlikView/Subtract-minutes/m-p/461209#M172181 MayilVahanan 2012-12-21T15:03:52Z Re: Subtract minutes https://community.qlik.com/t5/QlikView/Subtract-minutes/m-p/461210#M172182 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>vNo = 1; //Number of minutes or hours</P><P>=TimeStamp(now() - $(vNo)/(24*60)) for minutes</P><P>=TimeStamp(now() - $(vNo)/24) for hours</P></BODY></HTML> Fri, 21 Dec 2012 15:13:06 GMT https://community.qlik.com/t5/QlikView/Subtract-minutes/m-p/461210#M172182 CELAMBARASAN 2012-12-21T15:13:06Z