topic Re: Set Analysis: Filter date based on range in QlikView

topic Re: Set Analysis: Filter date based on range in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Filter-date-based-on-range/m-p/982673#M946464 <HTML><HEAD></HEAD><BODY><P>check this as well:</P><P></P><P><A href="https://community.qlik.com/thread/36922">The use of variables to filter a date range</A></P><P></P><P><A href="https://community.qlik.com/docs/DOC-5598">Date Selections - By Period &amp; Range</A></P><P></P><P><A href="http://www.min-maxing.com/blog/2012/07/20/easy-date-range-selection-with-qlikview/" title="http://www.min-maxing.com/blog/2012/07/20/easy-date-range-selection-with-qlikview/">Easy Date Range Selection with Qlikview | Min-Maxing</A></P><P></P><P><A href="https://community.qlik.com/thread/51857">Qlikview between dates filter</A></P></BODY></HTML> Thu, 24 Dec 2015 05:43:59 GMT Anonymous 2015-12-24T05:43:59Z Set Analysis: Filter date based on range https://community.qlik.com/t5/QlikView/Set-Analysis-Filter-date-based-on-range/m-p/982671#M946462 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>Here's my data:</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN></P><P>      </P><TABLE border="0" cellpadding="0" cellspacing="0" width="750"><TBODY><TR><TD width="151">Employee</TD><TD width="155">Date Assigned From</TD><TD width="162">Date Assigned To</TD><TD width="149">Actual Date</TD></TR><TR><TD class="xl66" height="16">1</TD><TD>X</TD><TD align="right" class="xl65">1/01/2015</TD><TD align="right" class="xl65">31/03/2015</TD><TD align="right" class="xl65">21/01/2015</TD></TR><TR><TD class="xl66" height="16">2</TD><TD>X</TD><TD align="right" class="xl65">1/01/2015</TD><TD align="right" class="xl65">31/03/2015</TD><TD align="right" class="xl65">21/02/2015</TD></TR><TR><TD class="xl66" height="16">3</TD><TD>X</TD><TD align="right" class="xl65">1/01/2015</TD><TD align="right" class="xl65">31/03/2015</TD><TD align="right" class="xl65">21/03/2015</TD></TR><TR><TD class="xl66" height="16">4</TD><TD>X</TD><TD align="right" class="xl65">1/01/2015</TD><TD align="right" class="xl65">31/03/2015</TD><TD align="right" class="xl65">21/04/2015</TD></TR><TR><TD class="xl66" height="16">5</TD><TD>X</TD><TD align="right" class="xl65">1/01/2015</TD><TD align="right" class="xl65">31/03/2015</TD><TD align="right" class="xl65">21/05/2015</TD></TR></TBODY></TABLE><P></P><P>and logic. Show only rows where Actual Date is between Date Assigned From and Date Assigned To.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Thu, 24 Dec 2015 04:11:38 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Filter-date-based-on-range/m-p/982671#M946462 k_burata 2015-12-24T04:11:38Z Re: Set Analysis: Filter date based on range https://community.qlik.com/t5/QlikView/Set-Analysis-Filter-date-based-on-range/m-p/982672#M946463 <HTML><HEAD></HEAD><BODY><P>You want to use as expression or Dimension??</P></BODY></HTML> Thu, 24 Dec 2015 05:38:28 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Filter-date-based-on-range/m-p/982672#M946463 Anonymous 2015-12-24T05:38:28Z Re: Set Analysis: Filter date based on range https://community.qlik.com/t5/QlikView/Set-Analysis-Filter-date-based-on-range/m-p/982673#M946464 <HTML><HEAD></HEAD><BODY><P>check this as well:</P><P></P><P><A href="https://community.qlik.com/thread/36922">The use of variables to filter a date range</A></P><P></P><P><A href="https://community.qlik.com/docs/DOC-5598">Date Selections - By Period &amp; Range</A></P><P></P><P><A href="http://www.min-maxing.com/blog/2012/07/20/easy-date-range-selection-with-qlikview/" title="http://www.min-maxing.com/blog/2012/07/20/easy-date-range-selection-with-qlikview/">Easy Date Range Selection with Qlikview | Min-Maxing</A></P><P></P><P><A href="https://community.qlik.com/thread/51857">Qlikview between dates filter</A></P></BODY></HTML> Thu, 24 Dec 2015 05:43:59 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Filter-date-based-on-range/m-p/982673#M946464 Anonymous 2015-12-24T05:43:59Z Re: Set Analysis: Filter date based on range https://community.qlik.com/t5/QlikView/Set-Analysis-Filter-date-based-on-range/m-p/982674#M946465 <HTML><HEAD></HEAD><BODY><P>Post a sample data...</P></BODY></HTML> Thu, 24 Dec 2015 05:55:55 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Filter-date-based-on-range/m-p/982674#M946465 kavita25 2015-12-24T05:55:55Z Re: Set Analysis: Filter date based on range https://community.qlik.com/t5/QlikView/Set-Analysis-Filter-date-based-on-range/m-p/982675#M946466 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">=if(<SPAN style="color: #3d3d3d; font-family: inherit; font-size: 10pt; font-style: inherit; font-weight: inherit;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Actual Date</SPAN>>=</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-style: inherit; font-weight: inherit;">Date Assigned From</SPAN> and <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Actual Date</SPAN><=</SPAN><SPAN style="font-weight: inherit; font-style: inherit;">Date Assigned To</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Actual Date</SPAN>)</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;"><BR /></SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;">like this you want?</SPAN></P></BODY></HTML> Thu, 24 Dec 2015 06:13:21 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Filter-date-based-on-range/m-p/982675#M946466 2015-12-24T06:13:21Z Re: Set Analysis: Filter date based on range https://community.qlik.com/t5/QlikView/Set-Analysis-Filter-date-based-on-range/m-p/982676#M946467 <HTML><HEAD></HEAD><BODY><P>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. </P></BODY></HTML> Tue, 29 Dec 2015 01:36:34 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Filter-date-based-on-range/m-p/982676#M946467 k_burata 2015-12-29T01:36:34Z