topic Re: Date range comparison between 2 tables help in QlikView

Date range comparison between 2 tables help

Wed, 15 Jun 2011 10:49:47 GMT

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

Re: Date range comparison between 2 tables help

kaushalview — Wed, 15 Jun 2011 13:01:31 GMT

Please Find attached file

Regrads

Kaushal Mehta

Re: Date range comparison between 2 tables help

Wed, 15 Jun 2011 13:22:44 GMT

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