Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kanimozhi
New Contributor II

help in script

hi all,

can anyone help to achieve the below result.

i have attached the sample data below.  need to apply the below 3 cases.

1. if type='cancel' take the 'id' and find the same 'id' from the previous record and delete both the records.

2. if mid=id then update the old record amt & hd_amt from the new record (as per date).

3. if if id>1 the only keep the latest record (as per date) drop all other rows for the same which contains the same id.

can refer 'expected result' in the same excel file for the output which i require.

thanks in advance

Tags (1)
2 Replies
vkish16161
Contributor III

Re: help in script

No file attached

kanimozhi
New Contributor II

Re: help in script

sorry missed the attachment before. PFA thnx

Community Browser