Issue with extracting data from tables

Thu, 04 Aug 2011 16:40:36 GMT

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

topic Issue with extracting data from tables in QlikView

Issue with extracting data from tables