topic Re: Loop through another table's Data to find row and value based on condition in App Development

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

Anonymous — Fri, 16 Mar 2018 04:27:49 GMT

I have 2 tables :
Table 1 :

Name

EntryDate

EntryTime

1/1/2018

10:15

1/1/2018

10:15

1/1/2018

12:15

1/1/2018

12:15

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

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

Anonymous — Fri, 16 Mar 2018 04:46:55 GMT

swuehl‌

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

Qrishna — Sat, 17 Mar 2018 04:38:31 GMT

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

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

Anonymous — Sun, 18 Mar 2018 03:47:05 GMT

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

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

paul_scotchford — Sun, 18 Mar 2018 23:22:02 GMT

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/ScriptRegularStatements/Binary.htm

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

Qrishna — Mon, 19 Mar 2018 00:51:06 GMT

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