5 Replies Latest reply: Mar 18, 2018 8:51 PM by Krishna Nagulapally RSS

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

    zo Chakrabarty

      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