Set analysis expression to filter out the date range

vijaiks — Mon, 24 Jul 2023 09:30:38 GMT

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

Re: Set analysis expression to filter out the date range

md_talib — Tue, 25 Jul 2023 12:48:24 GMT

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.

topic Set analysis expression to filter out the date range in QlikView

Set analysis expression to filter out the date range

Re: Set analysis expression to filter out the date range