topic Data ranges problem in QlikView

Data ranges problem

Thu, 09 Feb 2012 15:06:25 GMT

Hello i have a problem with data ranges.

i have a two tables

table1:

datefrom,dateto,exchrate

2010-01-01,2010-01-30,3.4

2010-02-01,2010-02-30,3.3

2010-03-01,2010-03-30,3.2

table2:

invoicedate,sales

2010-01-15,4

2010-02-15,7

2010-03-12,9

I want to table:

sales,exchrate

4,3.4

7,3.3

9,3.2

I can't to this. Please help me.

jagan — Thu, 09 Feb 2012 15:15:40 GMT

Hi,

Try using the Interval Match example in the Qlikview Reference Manual.

Regards,

Jagan.

jagan — Thu, 09 Feb 2012 15:17:27 GMT

Hi,

Check the following posts, it helps you.

Regards,

Jagan.