Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

Tags (2)
Community Browser