0 Replies Latest reply: Aug 4, 2011 12:40 PM by luisboero RSS

    Issue with extracting data from tables

      Hi

      I've been experimenting with QLV and have worked with 2 synthetic datasets linked by DATE field but with different length of the DATE dimension.

       

      So say

       

      Table1:

      Load Date

      Var1a

      Var2a

      From ...

       

      Table2:

      Load Date

      Var1b

      Var2b

      From ...

       

      Date in Table 1 spans 1 week, date in Table 2 spans 4 days within the week. Say one table has been more recently updated.

       

      Now I want to graph Sum (Var1) and Sum (Var2) for a period of say, 3 days from the latest COMMON date in Table 1 and Table 2.

       

      Let's say

       

      Date  Var1a ... Var2a

      10       100         20

      11        90          30

      12        98          17

      13       101          25

      14        98    

      15       110

      16       107

       

      So what I want is the Sum of (Var1a) and (Var2a) between date 13 (latest common occurrence) and date 11. Ideally, letting the user specify whether it's the last 3, 5 or whatever dates.

       

      Any views? Tried this simple thing to work and been hopeless.

       

      TIA

       

      Luis