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