topic Re: Expression Calculation in App Development https://community.qlik.com/t5/App-Development/Expression-Calculation/m-p/77997#M5184 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I think you wanted to say:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">If we do <STRONG>NOT</STRONG> have any data for that date ( "Information entered 14 days ago"), then we need to keep moving a day forward(13th day, 12th day etc) and consider the first </SPAN><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">available</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> information .</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Right ?</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">can you attach some data here ?<BR /></SPAN></P></BODY></HTML> Fri, 23 Mar 2018 09:33:14 GMT YoussefBelloum 2018-03-23T09:33:14Z Expression Calculation https://community.qlik.com/t5/App-Development/Expression-Calculation/m-p/77996#M5183 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>I am trying to do the below calculation:</P><P>(Latest Date Information - Information entered 14 days ago)/Information Entered 14 days ago</P><P></P><P>If we do have any data for that date ( "Information entered 14 days ago"), then we need to keep moving a day forward(13th day, 12th day etc) and consider the first <SPAN style="font-size: 13.3333px;">available</SPAN> information .</P><P></P><P>Please help me in doing the above calculation. </P><P></P><P>Thanks,</P><P>Monu</P></BODY></HTML> Fri, 23 Mar 2018 09:31:26 GMT https://community.qlik.com/t5/App-Development/Expression-Calculation/m-p/77996#M5183 sarasmonu 2018-03-23T09:31:26Z Re: Expression Calculation https://community.qlik.com/t5/App-Development/Expression-Calculation/m-p/77997#M5184 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I think you wanted to say:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">If we do <STRONG>NOT</STRONG> have any data for that date ( "Information entered 14 days ago"), then we need to keep moving a day forward(13th day, 12th day etc) and consider the first </SPAN><SPAN style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">available</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> information .</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Right ?</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">can you attach some data here ?<BR /></SPAN></P></BODY></HTML> Fri, 23 Mar 2018 09:33:14 GMT https://community.qlik.com/t5/App-Development/Expression-Calculation/m-p/77997#M5184 YoussefBelloum 2018-03-23T09:33:14Z