https://community.qlik.com/t5/App-Development/Issue-with-Straight-table/m-p/1812251#M66276 <P>Can anyone help me with this, I am stuck with this requirement</P> Tue, 01 Jun 2021 22:34:45 GMT saniyask 2021-06-01T22:34:45Z https://community.qlik.com/t5/App-Development/Issue-with-Straight-table/m-p/1811941#M66226 <P>Hello,</P><P>I have a straight table which gives me the below output based on my expressions.</P><TABLE><TBODY><TR><TD>Key</TD><TD>CARD_NUMBER</TD><TD>Doctor</TD><TD>Days_7</TD><TD>Date</TD><TD>Paid Amt</TD><TD>Recovery Amt</TD></TR><TR><TD>1294</TD><TD>17</TD><TD>0250888</TD><TD>0</TD><TD>30/Jan/2021</TD><TD>400</TD><TD>0</TD></TR><TR><TD>1294</TD><TD>17</TD><TD>0250888</TD><TD>0</TD><TD>18/Mar/2021</TD><TD>400</TD><TD>0</TD></TR><TR><TD>1294</TD><TD>18</TD><TD>0250888</TD><TD>0</TD><TD>14/Jan/2021</TD><TD>400</TD><TD>0</TD></TR><TR><TD>1294</TD><TD>19</TD><TD>0250888</TD><TD>0</TD><TD>17/Feb/2021</TD><TD>450</TD><TD>0</TD></TR><TR><TD>1294</TD><TD>19</TD><TD>0250888</TD><TD>0</TD><TD>13/Mar/2021</TD><TD>450</TD><TD>0</TD></TR><TR><TD>1294</TD><TD>21</TD><TD>0250888</TD><TD>0</TD><TD>11/Mar/2021</TD><TD>450</TD><TD>0</TD></TR><TR><TD>1294</TD><TD>21</TD><TD>0250888</TD><TD>7</TD><TD>18/Mar/2021</TD><TD>450</TD><TD>450</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Recovery Amount is checking the combination of <STRONG>Key, Card no, Doctor</STRONG> if all of these are the same for two different transactions within 7 days then its recovered or else it will be 0. which I have achieved.</P><P>But, now I want to show only those cards which have some recovery against them, So I should only get last line as my output along with the first transaction of that card within 7 days. (there can be cases where there are multiple transactions between day 0 to 7)</P><TABLE><TBODY><TR><TD>Key</TD><TD>CARD_NUMBER</TD><TD>Doctor</TD><TD>Days_7</TD><TD>Date</TD><TD>Paid Amt</TD><TD>Recovery Amt</TD></TR><TR><TD>1294</TD><TD>21</TD><TD>0250888</TD><TD>0</TD><TD>11/Mar/2021</TD><TD>450</TD><TD>0</TD></TR><TR><TD>1394</TD><TD>21</TD><TD>0250888</TD><TD>7</TD><TD>18/Mar/2021</TD><TD>450</TD><TD>450</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Any thoughts on how can I achieve this?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 00:05:45 GMT https://community.qlik.com/t5/App-Development/Issue-with-Straight-table/m-p/1811941#M66226 saniyask 2024-11-16T00:05:45Z https://community.qlik.com/t5/App-Development/Issue-with-Straight-table/m-p/1812251#M66276 <P>Can anyone help me with this, I am stuck with this requirement</P> Tue, 01 Jun 2021 22:34:45 GMT https://community.qlik.com/t5/App-Development/Issue-with-Straight-table/m-p/1812251#M66276 saniyask 2021-06-01T22:34:45Z