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

Sat, 13 Jul 2013 14:18:53 GMT

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??

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

Gysbert_Wassenaar — Sat, 13 Jul 2013 17:48:03 GMT