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: 
Anonymous
Not applicable

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

I have 2 tables :
Table 1 :

Name EntryDate EntryTime
A1/1/201810:15
B1/1/201810:15
C1/1/201812:15
A
1/1/2018
12:15
B
1/1/2018
12:15

Table 2 :

Name ExitDateExit TimeFlagearning
A

1/12018

9:15n100
A1/1201810:15n110
A1/1201812:15n115
A1/120181:15n120
B2/1201810:15Y114
A2/1201812:15n117
A3/1201810:15Y118

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:

NameEntryDateEntryTimeExitdateexittimeEarning
A1/1/201810:153/1/201810:15118
B1/1/201810:152/1/201810:15114

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

5 Replies
Anonymous
Not applicable
Author

swuehl

krishna_2644
Specialist III
Specialist III

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

1.PNG

Anonymous
Not applicable
Author

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
Specialist
Specialist

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...

krishna_2644
Specialist III
Specialist III

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