topic Reg: Pivot in QlikView https://community.qlik.com/t5/QlikView/Reg-Pivot/m-p/152087#M29670 <HTML><HEAD></HEAD><BODY><P>Hi Srividya ,</P><P>You can use the if condition for the same as below. It is working fine in my application.</P><P><STRONG>IF((Today()-DTIME)&gt;0,(Today()-DTIME)),0)</STRONG></P><P></P><P></P><BR /><BR /> <P></P><P></P></BODY></HTML> Tue, 04 Jan 2011 07:08:05 GMT 2011-01-04T07:08:05Z Reg: Pivot https://community.qlik.com/t5/QlikView/Reg-Pivot/m-p/152086#M29669 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>In a columns I have both +ive values as well as -ive values. But i want to show tht negative values must b in 'zero'.</P><P>Thanks in advance.</P><P>Regards,</P><P>Sri</P><P></P><P></P></BODY></HTML> Tue, 04 Jan 2011 06:57:16 GMT https://community.qlik.com/t5/QlikView/Reg-Pivot/m-p/152086#M29669 2011-01-04T06:57:16Z Reg: Pivot https://community.qlik.com/t5/QlikView/Reg-Pivot/m-p/152087#M29670 <HTML><HEAD></HEAD><BODY><P>Hi Srividya ,</P><P>You can use the if condition for the same as below. It is working fine in my application.</P><P><STRONG>IF((Today()-DTIME)&gt;0,(Today()-DTIME)),0)</STRONG></P><P></P><P></P><BR /><BR /> <P></P><P></P></BODY></HTML> Tue, 04 Jan 2011 07:08:05 GMT https://community.qlik.com/t5/QlikView/Reg-Pivot/m-p/152087#M29670 2011-01-04T07:08:05Z Reg: Pivot https://community.qlik.com/t5/QlikView/Reg-Pivot/m-p/152088#M29671 <HTML><HEAD></HEAD><BODY><P>Thanks Alot XXX</P><P>Its working fine</P><P>Thanks</P><P>Sri</P></BODY></HTML> Tue, 04 Jan 2011 07:25:16 GMT https://community.qlik.com/t5/QlikView/Reg-Pivot/m-p/152088#M29671 2011-01-04T07:25:16Z