Filtering from one table .Using the results to filter and aggregate another table

[#1]

I am new to qlickview(just been 3 days).I am stuck at how to approach my task.

Basically,I have a table table1 as:

ID     Date

1     16/7/13

2     17/7/13

3     20/7/13

I need to use start and end date as input and select IDs from table above such that 'Date' lies between start and end date.

There is another table table2 like:

ID     Name          Total_value          Total_count

1     name1          10                         1

1     name2          20                         2

2     name1          30                         10

2     name3          40                         20

3     name1          50                         30

The details from table2 should be filtered based on the IDs i get from table1 and aggregated and displayed in qlickview using the following logic:

select sum(total_value),sum(total_count),name from table2 group by name;

How do i approach this??

[Gysbert_Wassenaar]

See this tutorial: Selecting Arbitrary Date Ranges