topic pivot table with time selection between 2 dates in QlikView https://community.qlik.com/t5/QlikView/pivot-table-with-time-selection-between-2-dates/m-p/713774#M256887 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Selection date from 13/01/2014 till 16/01/2014</P><P></P><P>In column directive selecting and counting only the fields where EDI or EDI xx is mentioned (ONLY EDI ORDERS)</P><P>In column directive make a count of all orders</P><P></P><P>Need the foll result</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="333"><TBODY><TR><TD height="20" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri; border-style: none none solid; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;" width="76">Rijlabels</TD><TD style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri; border-style: none none solid; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;" width="117">ONLY EDI ORDERS</TD><TD style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri; border-style: none none solid; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;" width="140">Aantal van DIRECTIVE</TD></TR><TR><TD class="xl65" height="20">LO_BG</TD><TD align="right">2</TD></TR><TR><TD class="xl65" height="20">LO_TR</TD><TD align="right" class="xl66">2</TD><TD align="right">14</TD></TR><TR><TD class="xl65" height="20">LO_WG</TD><TD align="right" class="xl66">4</TD><TD align="right">4</TD></TR><TR><TD class="xl65" height="20" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #95b3d7; background: #dce6f1;">Eindtotaal</TD><TD align="right" class="xl66" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #95b3d7; background: #dce6f1;">6</TD><TD align="right" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #95b3d7; background: #dce6f1;">20</TD></TR></TBODY></TABLE><P></P><P>Can someone plse help me out</P><P></P><P>Tks</P><P></P><P>Rudi</P></BODY></HTML> Fri, 04 Jul 2014 09:53:56 GMT 2014-07-04T09:53:56Z pivot table with time selection between 2 dates https://community.qlik.com/t5/QlikView/pivot-table-with-time-selection-between-2-dates/m-p/713774#M256887 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Selection date from 13/01/2014 till 16/01/2014</P><P></P><P>In column directive selecting and counting only the fields where EDI or EDI xx is mentioned (ONLY EDI ORDERS)</P><P>In column directive make a count of all orders</P><P></P><P>Need the foll result</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="333"><TBODY><TR><TD height="20" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri; border-style: none none solid; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;" width="76">Rijlabels</TD><TD style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri; border-style: none none solid; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;" width="117">ONLY EDI ORDERS</TD><TD style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri; border-style: none none solid; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background: #dce6f1;" width="140">Aantal van DIRECTIVE</TD></TR><TR><TD class="xl65" height="20">LO_BG</TD><TD align="right">2</TD></TR><TR><TD class="xl65" height="20">LO_TR</TD><TD align="right" class="xl66">2</TD><TD align="right">14</TD></TR><TR><TD class="xl65" height="20">LO_WG</TD><TD align="right" class="xl66">4</TD><TD align="right">4</TD></TR><TR><TD class="xl65" height="20" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #95b3d7; background: #dce6f1;">Eindtotaal</TD><TD align="right" class="xl66" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #95b3d7; background: #dce6f1;">6</TD><TD align="right" style="font-size: 11pt; color: black; font-weight: bold; font-family: Calibri; border-top-width: 0.5pt; border-style: solid none none; border-top-color: #95b3d7; background: #dce6f1;">20</TD></TR></TBODY></TABLE><P></P><P>Can someone plse help me out</P><P></P><P>Tks</P><P></P><P>Rudi</P></BODY></HTML> Fri, 04 Jul 2014 09:53:56 GMT https://community.qlik.com/t5/QlikView/pivot-table-with-time-selection-between-2-dates/m-p/713774#M256887 2014-07-04T09:53:56Z