2 Replies Latest reply: Jun 15, 2011 9:22 AM by Jose Figueiredo RSS

    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