Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Date range comparison between 2 tables help

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

Tags (3)
2 Replies
kaushalview
Contributor II

Re: Date range comparison between 2 tables help

Hi

Please Find attached file

  Regrads

Kaushal Mehta

Not applicable

Re: Date range comparison between 2 tables help

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

Community Browser