2 Replies Latest reply: Oct 26, 2016 12:41 PM by Massimo Grossi RSS

    Lookup a value in another table

    Benjamin Czech

      All,


      I am pretty new to Qlikview and I am working on a Dashboard.


      I have two tables loaded in Qlikview.


      Table1 has the following columns: Date, org, invoice_count

      Table2 only has dates (but less dates than the dates in Table1)


      I am looking for a function that extends bable1 by another date column and it should pick the next date that is available in Table2 if the exact value cannot be found.


      Let's assume the tables look like this:


       

       

      Table 1

       


      DateOrganizationCount
      21-OCT-2016ABC5
      22-OCT-2016ABC10
      23-OCT-2016ABC8
      24-OCT-2016ABC5

       



      Table 2



      Dates
      20-OCT-2016
      21-OCT-2016
      24-OCT-2016
      25-OCT-2016

       


      So the extended Table 1 (or a new table should look like this:

      DateOrganizationCountNew_date
      21-OCT-2016ABC521-OCT-2016
      22-OCT-2016ABC1024-OCT-2016
      23-OCT-2016ABC824-OCT-2016
      24-OCT-2016ABC524-OCT-2016

       

      Are you aware of any way that this could be achieved?

       

      Thanks,

      Benny