Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
saniyask
Creator
Creator

Issue with Straight table

Hello,

I have a straight table which gives me the below output based on my expressions.

KeyCARD_NUMBERDoctorDays_7DatePaid AmtRecovery Amt
1294170250888030/Jan/20214000
1294170250888018/Mar/20214000
1294180250888014/Jan/20214000
1294190250888017/Feb/20214500
1294190250888013/Mar/20214500
1294210250888011/Mar/20214500
1294210250888718/Mar/2021450450

 

Recovery Amount is checking the combination of Key, Card no, Doctor 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.

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)

KeyCARD_NUMBERDoctorDays_7DatePaid AmtRecovery Amt
1294210250888011/Mar/20214500
1394210250888718/Mar/2021450450

 

Any thoughts on how can I achieve this?

 

 

 

Labels (1)
1 Reply
saniyask
Creator
Creator
Author

Can anyone help me with this, I am stuck with this requirement