Loop through another table's Data to find row and value based on condition

[Anonymous]

I have 2 tables :
Table 1 :

Name	EntryDate	EntryTime
A	1/1/2018	10:15
B	1/1/2018	10:15
C	1/1/2018	12:15
A	1/1/2018	12:15
B	1/1/2018	12:15

Table 2 :

Name	ExitDate	Exit Time	Flag	earning
A	1/12018	9:15	n	100
A	1/12018	10:15	n	110
A	1/12018	12:15	n	115
A	1/12018	1:15	n	120
B	2/12018	10:15	Y	114
A	2/12018	12:15	n	117
A	3/12018	10:15	Y	118

I want  a result table where Entrytime of A of is selected and it gives row of value of A from table 2 where flag is first Time Y aftrer  ExitTime> Entry time and entrydate<=Exitdate.

result Table:

Name	EntryDate	EntryTime	Exitdate	exittime	Earning
A	1/1/2018	10:15	3/1/2018	10:15	118
B	1/1/2018	10:15	2/1/2018	10:15	114

I'm Using qlik Sense .Is this Possible ?
Any help would be appreciated.
Thanks

[Anonymous]

swuehl‌

[Qrishna]

Check this out.The same logic is good for Qlik sense too.

[Anonymous]

HI Krishna Nagulapally
Thank you so much for taking out the time to answer my question.
But I am unable to use the the qvw file in qlik sense or I am unaware of how to use it./

it just adds the result table if i drag and drop it without any expressions or formulae,
is it possible to provide a solution which i can write in the expression builder of qlik sense
or if you could throw some light on how to use this qvw correctly.
Thanks Again
ZO

[paul_scotchford]

You can use the BINARY statement in your load script to import the .QVW

First read the help text to get familiar with the functionality ....

https://help.qlik.com/en-US/sense/November2017/Subsystems/Hub/Content/Scripting/ScriptRegularStateme...

[Qrishna]

Hy - u can just copy paste the script in your qvf and refresh it.