topic Max day issue in QlikView https://community.qlik.com/t5/QlikView/Max-day-issue/m-p/312957#M115526 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>my source is&nbsp; sankar_20.12.11.qvd</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192pt; border-collapse: collapse;" width="256"><TBODY><TR style="height: 15pt;"><TD height="20" style="width: 48pt; height: 15pt;" width="64">No</TD><TD style="width: 48pt;" width="64">name</TD><TD style="width: 48pt;" width="64">amt</TD><TD style="width: 48pt;" width="64">date</TD></TR><TR style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">1</TD><TD>sankar</TD><TD align="right">100</TD><TD>16.12.11</TD></TR><TR style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">2</TD><TD>sankar</TD><TD align="right">200</TD><TD>18.12.11</TD></TR><TR style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">3</TD><TD>sankar</TD><TD align="right">0</TD><TD>19.12.11</TD></TR><TR style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">4</TD><TD>sankar</TD><TD align="right">0</TD><TD>20.12.11</TD></TR></TBODY></TABLE><P>Here i am storing data day wise cumulative like below</P><P></P><P>sankar_16.12.11.qvd</P><P>sankar_18.12.11.qvd</P><P>sankar_19.12.11.qvd</P><P>sankar_20.12.11.qvd</P><P></P><P>In final application front end max(day)&nbsp; i am taking that time it is showing ZERO.it is right but my requirement is if max day or yesterday data&nbsp; and ....</P><P>is zero then it should display the 18th day data(if 18th data zero then display 16th day like)</P><P></P><P></P><P></P><P>Help me please</P><P></P><P>Regards</P><P>sankar</P></BODY></HTML> Tue, 20 Dec 2011 06:45:04 GMT 2011-12-20T06:45:04Z Max day issue https://community.qlik.com/t5/QlikView/Max-day-issue/m-p/312957#M115526 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>my source is&nbsp; sankar_20.12.11.qvd</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 192pt; border-collapse: collapse;" width="256"><TBODY><TR style="height: 15pt;"><TD height="20" style="width: 48pt; height: 15pt;" width="64">No</TD><TD style="width: 48pt;" width="64">name</TD><TD style="width: 48pt;" width="64">amt</TD><TD style="width: 48pt;" width="64">date</TD></TR><TR style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">1</TD><TD>sankar</TD><TD align="right">100</TD><TD>16.12.11</TD></TR><TR style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">2</TD><TD>sankar</TD><TD align="right">200</TD><TD>18.12.11</TD></TR><TR style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">3</TD><TD>sankar</TD><TD align="right">0</TD><TD>19.12.11</TD></TR><TR style="height: 15pt;"><TD align="right" height="20" style="height: 15pt;">4</TD><TD>sankar</TD><TD align="right">0</TD><TD>20.12.11</TD></TR></TBODY></TABLE><P>Here i am storing data day wise cumulative like below</P><P></P><P>sankar_16.12.11.qvd</P><P>sankar_18.12.11.qvd</P><P>sankar_19.12.11.qvd</P><P>sankar_20.12.11.qvd</P><P></P><P>In final application front end max(day)&nbsp; i am taking that time it is showing ZERO.it is right but my requirement is if max day or yesterday data&nbsp; and ....</P><P>is zero then it should display the 18th day data(if 18th data zero then display 16th day like)</P><P></P><P></P><P></P><P>Help me please</P><P></P><P>Regards</P><P>sankar</P></BODY></HTML> Tue, 20 Dec 2011 06:45:04 GMT https://community.qlik.com/t5/QlikView/Max-day-issue/m-p/312957#M115526 2011-12-20T06:45:04Z Max day issue https://community.qlik.com/t5/QlikView/Max-day-issue/m-p/312958#M115527 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P>You can use&nbsp; Max(If(amt&gt;0,date)&nbsp; </P><P>Regards</P><P>VIjay</P></BODY></HTML> Tue, 20 Dec 2011 07:02:38 GMT https://community.qlik.com/t5/QlikView/Max-day-issue/m-p/312958#M115527 vijay_iitkgp 2011-12-20T07:02:38Z