topic Re: Conditional against row data in QlikView https://community.qlik.com/t5/QlikView/Conditional-against-row-data/m-p/474030#M1145291 <HTML><HEAD></HEAD><BODY><P>Many Thanks</P><P></P><P>Worked a charm</P></BODY></HTML> Thu, 08 Aug 2013 08:24:50 GMT 2013-08-08T08:24:50Z Conditional against row data https://community.qlik.com/t5/QlikView/Conditional-against-row-data/m-p/474028#M1145289 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I have a Chart table of Meter Serial Numbers and a last reading date(MAX). </P><P></P><P>I only want the to display the records that have calculate&nbsp; Today() - Max[Reading Date] &gt; 2 . </P><P></P><P>Please see attached</P><P></P><P>Any help would be wonderful. </P></BODY></HTML> Wed, 07 Aug 2013 17:04:29 GMT https://community.qlik.com/t5/QlikView/Conditional-against-row-data/m-p/474028#M1145289 2013-08-07T17:04:29Z Re: Conditional against row data https://community.qlik.com/t5/QlikView/Conditional-against-row-data/m-p/474029#M1145290 <HTML><HEAD></HEAD><BODY><P>use the below expression in ur chart.</P><P></P><P>if(Today() - Max([Reading Date]) &gt; 2,Metricfield)</P><P></P><P>Regards,</P><P>Kabilan K.</P></BODY></HTML> Thu, 08 Aug 2013 07:39:57 GMT https://community.qlik.com/t5/QlikView/Conditional-against-row-data/m-p/474029#M1145290 2013-08-08T07:39:57Z Re: Conditional against row data https://community.qlik.com/t5/QlikView/Conditional-against-row-data/m-p/474030#M1145291 <HTML><HEAD></HEAD><BODY><P>Many Thanks</P><P></P><P>Worked a charm</P></BODY></HTML> Thu, 08 Aug 2013 08:24:50 GMT https://community.qlik.com/t5/QlikView/Conditional-against-row-data/m-p/474030#M1145291 2013-08-08T08:24:50Z