Date range comparison between 2 tables help

[#1]

It may a silly question but I'm new to QlikView.

I have 2 tables A and B, date range filter and 2 charts to give me information based on my date filter

Chart1 - I would like to display the total Value from table B as long as the TransactionDate is within the filter range.

Chart2 - I would like to display the following

          1 - Match records in table A based on the filter range

          2 - Get the Account Date

          3 - Get total value as long the TransactionDate is greater than the AccountDate.

... And I'm obviously doing something wrong as I'm not getting any data, I'm also attaching the file.

Your help will be appreciated

Thanks

Jose

[kaushalview]

Hi

Please Find attached file

  Regrads

Kaushal Mehta

[#3]

Hi Kaushal,

Thanks for your reply but if I changed the Date From to 01/02/2010 and Date To 28/02/2010I should see some transactions in Table B and chart 2 should display sum of value table B as long the TransactionDate is greater than the AccountDate, but I'm not getting any ... I'm using the wrong function?

Please see file attached with date selected.

Many thanks

Jose