Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Please Find attached file
Regrads
Kaushal Mehta
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