topic Re: help on pivot table in QlikView

topic Re: help on pivot table in QlikView https://community.qlik.com/t5/QlikView/help-on-pivot-table/m-p/452705#M698459 <HTML><HEAD></HEAD><BODY><P>hiiii</P><P>see the attached file</P></BODY></HTML> Thu, 24 Jan 2013 10:49:05 GMT er_mohit 2013-01-24T10:49:05Z help on pivot table https://community.qlik.com/t5/QlikView/help-on-pivot-table/m-p/452704#M698458 <HTML><HEAD></HEAD><BODY><P>I have a sql table ‘TAB1’ that is more or less like this :</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none; padding: 0 5.4pt 0 5.4pt;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">DATE</SPAN></STRONG></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">TYPE</SPAN></STRONG></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">CODE</SPAN></STRONG></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">EMPLOYEE</SPAN></STRONG></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">FATHERCODE</SPAN></STRONG></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/01/2010</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CONTRACT</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON001</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center"></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center"></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/02/2010</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">TECHNICAL INTERVENTION</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">-</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">MARK</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON001</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/03/2010</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">TECHNICAL INTERVENTION</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">-</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">MARK</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON001</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/04/2010</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">TECHNICAL INTERVENTION</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">-</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">JOHN</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON001</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/05/2010</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CONTRACT</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON002</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center"></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center"></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/06/2010</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">TECHNICAL INTERVENTION</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">-</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">DAVID</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON002</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/07/2010</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">TECHNICAL INTERVENTION</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">-</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">PAUL</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON002</P></TD></TR></TBODY></TABLE><P></P><P>I’m trying to obtain this pivot table :</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none; padding: 0 5.4pt 0 5.4pt;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="112"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">DATE</SPAN></STRONG></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="127"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">TYPE</SPAN></STRONG></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="120"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">CODE</SPAN></STRONG></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">DATE INTERVENTIONS</SPAN></STRONG></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">EMPLOYEE</SPAN></STRONG></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="112"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/01/2010</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="127"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CONTRACT</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="120"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON001</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"> -</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">- </P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="112"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"> -</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="127"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"> -</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="120"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">- </P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/02/2010</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">MARK</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="112"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"> -</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="127"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"> -</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="120"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"> -</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/03/2010</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">MARK</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="112"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"> -</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="127"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"> -</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="120"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"> -</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/04/2010</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">JOHN</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="112"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/05/2010</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="127"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CONTRACT</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="120"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON001</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">- </P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">- </P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="112"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"> -</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="127"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"> -</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="120"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"> -</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/06/2010</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">DAVID</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="112"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"> -</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="127"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">- </P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="120"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"> -</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/07/2010</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="99"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">PAUL</P></TD></TR></TBODY></TABLE><P>                                     DIMENSIONS                                                                         EXPRESSIONS</P><P></P><P>What do you suggest ?</P><P></P><P>Please help !!!</P><P></P><P>Marco</P></BODY></HTML> Thu, 24 Jan 2013 10:06:45 GMT https://community.qlik.com/t5/QlikView/help-on-pivot-table/m-p/452704#M698458 marcorizzo 2013-01-24T10:06:45Z Re: help on pivot table https://community.qlik.com/t5/QlikView/help-on-pivot-table/m-p/452705#M698459 <HTML><HEAD></HEAD><BODY><P>hiiii</P><P>see the attached file</P></BODY></HTML> Thu, 24 Jan 2013 10:49:05 GMT https://community.qlik.com/t5/QlikView/help-on-pivot-table/m-p/452705#M698459 er_mohit 2013-01-24T10:49:05Z Re: help on pivot table https://community.qlik.com/t5/QlikView/help-on-pivot-table/m-p/452706#M698460 <HTML><HEAD></HEAD><BODY><P>Sorry but it doesn't work.</P><P></P><P>I was wrong because the sql table is a bit different :</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">DATE</SPAN></STRONG></P></TD><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-left: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">TYPE</SPAN></STRONG></P></TD><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-left: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">CODE</SPAN></STRONG></P></TD><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-left: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">EMPLOYEE</SPAN></STRONG></P></TD><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-left: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;"><STRONG><SPAN lang="EN-US" style="font-size: 14.0pt;">FATHERCODE</SPAN></STRONG></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/01/2010</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CONTRACT</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON001</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center"></P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center"></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/02/2010</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CONTRACT</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON002</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center"></P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center"></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/03/2010</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">TECHNICAL INTERVENTION</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">-</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">MARK</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON001</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/04/2010</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">TECHNICAL INTERVENTION</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">-</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">JOHN</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON002</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/05/2010</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">TECHNICAL INTERVENTION</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">-</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center">PAUL </P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center">CON002 </P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/06/2010</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">TECHNICAL INTERVENTION</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">-</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">DAVID</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON001</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">01/07/2010</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">TECHNICAL INTERVENTION</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">-</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">PAUL</P></TD><TD style="border: none; padding: 0 5.4pt 0 5.4pt; border-right: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-left: none; border-top: none;" width="109"><P align="center" style="margin-bottom: 0.0001pt; text-align: center;">CON002</P></TD></TR></TBODY></TABLE><P></P><P>So I cannot use the date ad dimension.</P><P></P><P>I really don't know how to go on.</P></BODY></HTML> Sat, 16 Feb 2013 18:50:34 GMT https://community.qlik.com/t5/QlikView/help-on-pivot-table/m-p/452706#M698460 marcorizzo 2013-02-16T18:50:34Z