Set Analysis: Filter date based on range

[k_burata]

Hi,

I have a pivot chart and using Set analysis want to hide rows if the Actual Date is not within the From and To Dates. I have created a Calculated Dimension but doesn't seem to work with date ranges.

Here's my data:

Employee	Date Assigned From	Date Assigned To	Actual Date
1	X	1/01/2015	31/03/2015	21/01/2015
2	X	1/01/2015	31/03/2015	21/02/2015
3	X	1/01/2015	31/03/2015	21/03/2015
4	X	1/01/2015	31/03/2015	21/04/2015
5	X	1/01/2015	31/03/2015	21/05/2015

and logic. Show only rows where Actual Date is between Date Assigned From and Date Assigned To.

Thanks in advance.

[Anonymous]

You want to use as expression or Dimension??

[Anonymous]

check this as well:

The use of variables to filter a date range

Date Selections - By Period & Range

Easy Date Range Selection with Qlikview | Min-Maxing

Qlikview between dates filter

[kavita25]

Post a sample data...

[#5]

=if(Actual Date>=Date Assigned From and Actual Date<=Date Assigned To,Actual Date)

like this you want?

[k_burata]

I am actually trying to do it that the rows in the pivot chart is shown when the actual date is inbetween date assigend from and date assigned to.