Qlik Community

Qlik Sense App Development

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

soham_raul
New Contributor

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
soham_raul
New Contributor

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

swuehl

krishna_2644
Valued Contributor III

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

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

1.PNG

soham_raul
New Contributor

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

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
Valued Contributor

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

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
Valued Contributor III

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

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

Community Browser