topic Re: Re: Filtering pivot with date variables in QlikView https://community.qlik.com/t5/QlikView/Filtering-pivot-with-date-variables/m-p/624347#M478598 <HTML><HEAD></HEAD><BODY><P>Pls check pivottable RK in attached example.</P><P></P><P>BTW: Is</P><P>Min(DATA_RIF_DOC)&nbsp; = 10/06/2009 ?</P><P>max(DATA_RIF_DOC)&nbsp; = 13/01/2009 ?</P><P>correct ?</P><P>Do you mean 13/01/2010</P></BODY></HTML> Tue, 11 Mar 2014 15:52:25 GMT 2014-03-11T15:52:25Z Filtering pivot with date variables https://community.qlik.com/t5/QlikView/Filtering-pivot-with-date-variables/m-p/624343#M478594 <HTML><HEAD></HEAD><BODY><P>Hi I'm new in Qlikview and I need help to create a pivot table from the follow excel table</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1107px;"><TBODY><TR><TD class="xl63" height="17" width="68">C_CLIENTE</TD><TD class="xl63" style="border-left: none;" width="82">C_LINEA_FAT</TD><TD class="xl63" style="border-left: none;" width="105">C_LISTINO_RIGA</TD><TD class="xl63" style="border-left: none;" width="94">DATA_FATTURA</TD><TD class="xl63" style="border-left: none;" width="94">DATA_RIF_DOC</TD><TD class="xl63" style="border-left: none;" width="39">Group</TD><TD class="xl63" style="border-left: none;" width="34">mese</TD><TD class="xl63" style="border-left: none;" width="101">P_SC_CAN1_CNT</TD><TD class="xl63" style="border-left: none;" width="101">P_SC_CAN2_CNT</TD><TD class="xl63" style="border-left: none;" width="101">P_SC_CAN3_CNT</TD><TD class="xl63" style="border-left: none;" width="105">P_SC_COMP_CNT</TD><TD class="xl63" style="border-left: none;" width="183">P_SC_DERIVA_COMPLETA_CNT</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">C0000009</TD><TD class="xl64" style="border-top: none; border-left: none;">005</TD><TD class="xl64" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">15/01/2009</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">07/01/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">588</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD class="xl64" style="border-top: none; border-left: none;">0,1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,450001666</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">C0000009</TD><TD class="xl64" style="border-top: none; border-left: none;">005</TD><TD class="xl64" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">15/01/2009</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">12/01/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">588</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD class="xl64" style="border-top: none; border-left: none;">0,1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,450001666</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">C0000009</TD><TD class="xl64" style="border-top: none; border-left: none;">005</TD><TD class="xl64" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">15/01/2009</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">13/01/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">588</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD class="xl64" style="border-top: none; border-left: none;">0,1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,450001666</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">C0000009</TD><TD class="xl64" style="border-top: none; border-left: none;">005</TD><TD class="xl64" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">15/01/2009</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">14/01/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">588</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD class="xl64" style="border-top: none; border-left: none;">0,1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,450001666</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">C0000009</TD><TD class="xl64" style="border-top: none; border-left: none;">005</TD><TD class="xl64" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">31/01/2009</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">15/01/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">588</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD class="xl64" style="border-top: none; border-left: none;">0,1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,450001666</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">C0000009</TD><TD class="xl64" style="border-top: none; border-left: none;">005</TD><TD class="xl64" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">31/01/2009</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">16/01/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">589</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD class="xl64" style="border-top: none; border-left: none;">0,15</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,480557129</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">C0000009</TD><TD class="xl64" style="border-top: none; border-left: none;">003</TD><TD class="xl64" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">31/01/2009</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">20/01/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">586</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD class="xl64" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,38889074</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">C0000009</TD><TD class="xl64" style="border-top: none; border-left: none;">003</TD><TD class="xl64" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">31/01/2009</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">28/01/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">586</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD class="xl64" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,38889074</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">C0000009</TD><TD class="xl64" style="border-top: none; border-left: none;">003</TD><TD class="xl64" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">15/02/2009</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">03/02/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">586</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD class="xl64" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,38889074</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">C0000009</TD><TD class="xl68" style="border-top: none; border-left: none;">003</TD><TD class="xl68" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">15/02/2009</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">11/02/2009</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">586</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0</TD><TD class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0,38889074</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">C0000009</TD><TD class="xl68" style="border-top: none; border-left: none;">003</TD><TD class="xl68" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">28/02/2009</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">17/02/2009</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">586</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0</TD><TD class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0,38889074</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">C0000009</TD><TD class="xl68" style="border-top: none; border-left: none;">003</TD><TD class="xl68" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">15/03/2009</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">03/03/2009</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">586</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0</TD><TD class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0,38889074</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">C0000009</TD><TD class="xl68" style="border-top: none; border-left: none;">003</TD><TD class="xl68" style="border-top: none; border-left: none;">000089</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">15/03/2009</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">03/03/2009</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">587</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0</TD><TD class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0,38889074</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">C0000009</TD><TD class="xl64" style="border-top: none; border-left: none;">003</TD><TD class="xl64" style="border-top: none; border-left: none;">000089</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">15/03/2009</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">11/03/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">587</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD class="xl64" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,38889074</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">C0000009</TD><TD class="xl64" style="border-top: none; border-left: none;">003</TD><TD class="xl64" style="border-top: none; border-left: none;">000089</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">31/03/2009</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">17/03/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">587</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD><TD class="xl64" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0,38889074</TD></TR></TBODY></TABLE><P></P><P>in qlikview document I added two slider object for filterig by DATA_RIF_DOC</P><P>In the pivot i need to have C_CLIENTE as dimension and as expression for the max Group field for the selection period the values of fields</P><P></P><P>P_SC_CAN1_CNT</P><P>P_SC_CAN2_CNT</P><P>P_SC_DERIVA_COMPLETA_CNT</P><P>MIN(DATA_RIF_DOC)</P><P>MAX(DATA_RIF_DOC)</P><P></P><P>I attach a sample document with data</P><P></P><P>I have tried using FirstSortedValue. </P><P></P><P>is the correct way?</P><P></P><P>Can someone help me?</P><P></P><P>thanks</P></BODY></HTML> Tue, 11 Mar 2014 13:17:22 GMT https://community.qlik.com/t5/QlikView/Filtering-pivot-with-date-variables/m-p/624343#M478594 paolojolly 2014-03-11T13:17:22Z Re: Filtering pivot with date variables https://community.qlik.com/t5/QlikView/Filtering-pivot-with-date-variables/m-p/624344#M478595 <HTML><HEAD></HEAD><BODY><P>Ho Paolo,</P><P>didn't catch exactly what you want, so check my guesses.</P><P>Hope this points into right direction.</P><P>Roland</P></BODY></HTML> Tue, 11 Mar 2014 14:15:02 GMT https://community.qlik.com/t5/QlikView/Filtering-pivot-with-date-variables/m-p/624344#M478595 2014-03-11T14:15:02Z Re: Filtering pivot with date variables https://community.qlik.com/t5/QlikView/Filtering-pivot-with-date-variables/m-p/624345#M478596 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Firstly you need to upload the excel file ( which contains data only) in the QV and the create Pivot table there.</P><P></P><P>Happy Qliking <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 11 Mar 2014 14:27:03 GMT https://community.qlik.com/t5/QlikView/Filtering-pivot-with-date-variables/m-p/624345#M478596 ashwanin 2014-03-11T14:27:03Z Re: Filtering pivot with date variables https://community.qlik.com/t5/QlikView/Filtering-pivot-with-date-variables/m-p/624346#M478597 <HTML><HEAD></HEAD><BODY><P>Maybe I have not explained properly my problem. For example, i set date variable in the slider from 10/06/2009 to 13/01/2009</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1213px;"><TBODY><TR><TD class="xl63" height="20" width="71">C_CLIENTE</TD><TD class="xl63" style="border-left: none;" width="88">C_LINEA_FAT</TD><TD class="xl63" style="border-left: none;" width="109">C_LISTINO_RIGA</TD><TD class="xl64" style="border-left: none;" width="41">mese</TD><TD class="xl63" style="border-left: none;" width="106">DATA_FATTURA</TD><TD class="xl63" style="border-left: none;" width="102">DATA_RIF_DOC</TD><TD class="xl63" style="border-left: none;" width="46">Group</TD><TD class="xl63" style="border-left: none;" width="111">P_SC_CAN1_CNT</TD><TD class="xl63" style="border-left: none;" width="111">P_SC_CAN2_CNT</TD><TD class="xl63" style="border-left: none;" width="111">P_SC_CAN3_CNT</TD><TD class="xl63" style="border-left: none;" width="116">P_SC_COMP_CNT</TD><TD class="xl63" style="border-left: none;" width="201">P_SC_DERIVA_COMPLETA_CNT</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">C0000009</TD><TD class="xl65" style="border-top: none; border-left: none;">003</TD><TD class="xl65" style="border-top: none; border-left: none;">000089</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15/06/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">03/06/2009</TD><TD class="xl65" style="border-top: none; border-left: none;">587</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl65" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0,38889074</TD></TR><TR><TD class="xl69" height="20" style="border-top: none;">C0000009</TD><TD class="xl69" style="border-top: none; border-left: none;">003</TD><TD class="xl69" style="border-top: none; border-left: none;">000089</TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">15/06/2009</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>10/06/2009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>587</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,19</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,38889074</STRONG></TD></TR><TR><TD class="xl69" height="20" style="border-top: none;"><STRONG>C0000009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>003</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>000089</STRONG></TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><STRONG>0,00</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>30/06/2009</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>16/06/2009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>587</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,19</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,38889074</STRONG></TD></TR><TR><TD class="xl69" height="20" style="border-top: none;"><STRONG>C0000009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>003</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>000089</STRONG></TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><STRONG>0,00</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>30/06/2009</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>24/06/2009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>587</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,19</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,38889074</STRONG></TD></TR><TR><TD class="xl69" height="20" style="border-top: none;"><STRONG>C0000009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>003</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>000089</STRONG></TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><STRONG>1,00</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>15/07/2009</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>30/06/2009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>587</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,19</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,38889074</STRONG></TD></TR><TR><TD class="xl69" height="20" style="border-top: none;"><STRONG>C0000009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>003</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>000089</STRONG></TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><STRONG>0,00</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>15/07/2009</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>08/07/2009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>587</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,19</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,38889074</STRONG></TD></TR><TR><TD class="xl69" height="20" style="border-top: none;"><STRONG>C0000009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>003</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>000089</STRONG></TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><STRONG>0,00</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>15/07/2009</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>14/07/2009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>587</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,19</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,38889074</STRONG></TD></TR><TR><TD class="xl69" height="20" style="border-top: none;"><STRONG>C0000009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>005</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>000085</STRONG></TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><STRONG>0,00</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>15/01/2009</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>07/01/2009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>588</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,19</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>0,1</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,450001666</STRONG></TD></TR><TR><TD class="xl69" height="20" style="border-top: none;"><STRONG>C0000009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>005</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>000085</STRONG></TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><STRONG>0,00</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>15/01/2009</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>12/01/2009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>588</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,19</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>0,1</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,450001666</STRONG></TD></TR><TR><TD class="xl69" height="20" style="border-top: none;"><STRONG>C0000009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>005</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>000085</STRONG></TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><STRONG>0,00</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>15/01/2009</STRONG></TD><TD align="right" class="xl71" style="border-top: none; border-left: none;"><STRONG>13/01/2009</STRONG></TD><TD class="xl69" style="border-top: none; border-left: none;"><STRONG>588</STRONG></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><STRONG>0,</STRONG>19</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0</TD><TD class="xl69" style="border-top: none; border-left: none;">0,1</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">0,450001666</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">C0000009</TD><TD class="xl65" style="border-top: none; border-left: none;">005</TD><TD class="xl65" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15/01/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">14/01/2009</TD><TD class="xl65" style="border-top: none; border-left: none;">588</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl65" style="border-top: none; border-left: none;">0,1</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0,450001666</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">C0000009</TD><TD class="xl65" style="border-top: none; border-left: none;">005</TD><TD class="xl65" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">31/01/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15/01/2009</TD><TD class="xl65" style="border-top: none; border-left: none;">588</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl65" style="border-top: none; border-left: none;">0,1</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0,450001666</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">C0000009</TD><TD class="xl65" style="border-top: none; border-left: none;">005</TD><TD class="xl65" style="border-top: none; border-left: none;">000085</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">0,00</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">31/01/2009</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">16/01/2009</TD><TD class="xl65" style="border-top: none; border-left: none;">589</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl65" style="border-top: none; border-left: none;">0,15</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0,480557129</TD></TR></TBODY></TABLE><P></P><P>and in the pivot i need to get only 1 record like </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 1031px;"><TBODY><TR><TD class="xl65" height="40" width="71">C_CLIENTE</TD><TD class="xl65" style="border-left: none;" width="88">Group</TD><TD class="xl65" style="border-left: none;" width="111">P_SC_CAN1_CNT</TD><TD class="xl65" style="border-left: none;" width="111">P_SC_CAN2_CNT</TD><TD class="xl65" style="border-left: none;" width="111">P_SC_CAN3_CNT</TD><TD class="xl65" style="border-left: none;" width="116">P_SC_COMP_CNT</TD><TD class="xl65" style="border-left: none;" width="201">P_SC_DERIVA_COMPLETA_CNT</TD><TD class="xl66" style="border-left: none;" width="111">min<BR /> DATA_RIF_DOC</TD><TD class="xl66" style="border-left: none;" width="111">max<BR /> DATA_RIF_DOC</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">C0000009</TD><TD class="xl67" style="border-top: none; border-left: none;">588</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0,19</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0</TD><TD class="xl67" style="border-top: none; border-left: none;">0,1</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">0,450001666</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">10/06/2009</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><P>13/01/2009</P></TD></TR></TBODY></TABLE><P></P><P>in which for the max&nbsp; Group values in the selection period(588) are shows the corresponding values ​​of </P><TABLE><TBODY><TR><TD>P_SC_CAN1_CNT</TD><TD></TD></TR><TR><TD>P_SC_CAN2_CNT</TD><TD></TD></TR><TR><TD>P_SC_CAN3_CNT</TD><TD></TD></TR><TR><TD>P_SC_COMP_CNT</TD><TD></TD></TR></TBODY></TABLE><P>P_SC_DERIVA_COMPLETA_CNT</P><P>and the min e max values of field DATA_RIF_DOC</P><P></P><P>thanks for your help</P></BODY></HTML> Tue, 11 Mar 2014 14:47:29 GMT https://community.qlik.com/t5/QlikView/Filtering-pivot-with-date-variables/m-p/624346#M478597 paolojolly 2014-03-11T14:47:29Z Re: Re: Filtering pivot with date variables https://community.qlik.com/t5/QlikView/Filtering-pivot-with-date-variables/m-p/624347#M478598 <HTML><HEAD></HEAD><BODY><P>Pls check pivottable RK in attached example.</P><P></P><P>BTW: Is</P><P>Min(DATA_RIF_DOC)&nbsp; = 10/06/2009 ?</P><P>max(DATA_RIF_DOC)&nbsp; = 13/01/2009 ?</P><P>correct ?</P><P>Do you mean 13/01/2010</P></BODY></HTML> Tue, 11 Mar 2014 15:52:25 GMT https://community.qlik.com/t5/QlikView/Filtering-pivot-with-date-variables/m-p/624347#M478598 2014-03-11T15:52:25Z