Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Reply
Gysbert_Wassenaar

See this tutorial: Selecting Arbitrary Date Ranges


talk is cheap, supply exceeds demand