Set analysis expression to filter out the date range

[vijaiks]

Hi all,

I have two tables which I will list below. 

From these two table I want to create a bar chart. After created the chart I make the phase as dimension. Now I want to show how many projects completed in the each phase as count in the bar. For that completion_date wants to lie inside between Start and End date. I don't want to make any corrections in the loading script like IntervalMatch, ApplyMap etc..

I want to write it as a set expression like,

But it is showing as no data to display. Please help me to write the expression for the bar chart in @qlikview 

[md_talib]

you need to create dates for both tables then make key for Dates. 

create a yearmonth field using the dates. 

now your yearmonth selection will work on both the tables.