What should be Set Expression / Data Model for expected output ?

[prahlad_infy]

Hello Sirs ,

In continuation to existing problem for which i did not get any solution and being a newbie i am struggling to find .
Possible reason for it might be , that i failed to sharing simple data and outcome .

,Please help on data model . Not sure what to do get needed result

Here i am sharing simple data and output expected  . Please help .

first table

second table

result requesting

[qlikviewwizard]

Hi prahlad.infy

Your requirement is not clear.

Please explain the logic to each column in the expected output. Thank you.

[prahlad_infy]

Thank for replying

Please let me know , if this helps .

[prahlad_infy]

Any update sir ?