topic Re: Formato de tabla pivotante in QlikView https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573649#M1103944 <HTML><HEAD></HEAD><BODY><P>send me your example, I'll help you ...</P></BODY></HTML> Mon, 14 Apr 2014 10:30:15 GMT alexandros17 2014-04-14T10:30:15Z Formato de tabla pivotante https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573646#M1103941 <HTML><HEAD></HEAD><BODY><P>Hola, </P><P></P><P>Estoy intentando crear una tabla pivotante y tengo el siguiente problema:</P><P></P><P>- Tabla de clientes (Id Cliente y Fecha compra(de donde saco el año))</P><P>- Tabla de compras (Id Compra, Id Cliente, tipo compra)</P><P></P><P>Quiero mostrar la información en una tabla como muestro en la imagen adjunta (tal y como lo hacía con Power Pivot).</P><P></P><P>No soy capaz de mostrar la información por año, y dentro de los años el número de compras y el porcentaje de las mismas en base a cada año)</P></BODY></HTML> Mon, 14 Apr 2014 10:18:32 GMT https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573646#M1103941 2014-04-14T10:18:32Z Re: Formato de tabla pivotante https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573647#M1103942 <HTML><HEAD></HEAD><BODY><P>Drag year with your mouse over other fields ...</P></BODY></HTML> Mon, 14 Apr 2014 10:22:05 GMT https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573647#M1103942 alexandros17 2014-04-14T10:22:05Z Re: Formato de tabla pivotante https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573648#M1103943 <HTML><HEAD></HEAD><BODY><P>Where? In expresions or dimensions?</P></BODY></HTML> Mon, 14 Apr 2014 10:27:35 GMT https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573648#M1103943 2014-04-14T10:27:35Z Re: Formato de tabla pivotante https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573649#M1103944 <HTML><HEAD></HEAD><BODY><P>send me your example, I'll help you ...</P></BODY></HTML> Mon, 14 Apr 2014 10:30:15 GMT https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573649#M1103944 alexandros17 2014-04-14T10:30:15Z Re: Formato de tabla pivotante https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573650#M1103945 <HTML><HEAD></HEAD><BODY><P>How can I send you the example?</P></BODY></HTML> Mon, 14 Apr 2014 11:29:35 GMT https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573650#M1103945 2014-04-14T11:29:35Z Re: Formato de tabla pivotante https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573651#M1103946 <HTML><HEAD></HEAD><BODY><P>Click on answer and use advanced editor so you can attach a file ...</P></BODY></HTML> Mon, 14 Apr 2014 11:32:45 GMT https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573651#M1103946 alexandros17 2014-04-14T11:32:45Z Re: Re: Formato de tabla pivotante https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573652#M1103947 <HTML><HEAD></HEAD><BODY><P>Here you have. Thanks in advance!</P></BODY></HTML> Mon, 14 Apr 2014 13:16:23 GMT https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573652#M1103947 2014-04-14T13:16:23Z Re: Re: Re: Formato de tabla pivotante https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573653#M1103948 <HTML><HEAD></HEAD><BODY><P>Here it is my example</P></BODY></HTML> Mon, 14 Apr 2014 13:42:08 GMT https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573653#M1103948 alexandros17 2014-04-14T13:42:08Z Re: Re: Formato de tabla pivotante https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573654#M1103949 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I can't open it...</SPAN></P><P></P><P><IMG alt="QV.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/57236_QV.JPG.jpg" style="width: 620px; height: 496px;" /></P></BODY></HTML> Mon, 14 Apr 2014 13:49:53 GMT https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573654#M1103949 2014-04-14T13:49:53Z Re: Re: Formato de tabla pivotante https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573655#M1103950 <HTML><HEAD></HEAD><BODY><P>If you have personal edition you cannot open it ...</P><P></P><P>Let me know</P></BODY></HTML> Mon, 14 Apr 2014 14:03:22 GMT https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573655#M1103950 alexandros17 2014-04-14T14:03:22Z Re: Re: Formato de tabla pivotante https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573656#M1103951 <HTML><HEAD></HEAD><BODY><P>Yes, I have the Personal Edition...</P></BODY></HTML> Mon, 14 Apr 2014 14:07:46 GMT https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573656#M1103951 2014-04-14T14:07:46Z Re: Re: Formato de tabla pivotante https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573657#M1103952 <HTML><HEAD></HEAD><BODY><P>1) Create a Pivot Table</P><P>2) add 2 dimension: Tipo Compra, AnoCompra</P><P>3) add 2 expressions: </P><P>&nbsp;&nbsp;&nbsp;&nbsp; sum(Cantidad)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum(Cantidad)/Aggr(NODISTINCT Sum(Cantidad), AñoCompra)</P><P>4) click on AnoCompra and (do not release mouse button) drag to the upper right of the table until you see an horizontal line, then unclick.&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Mon, 14 Apr 2014 14:12:05 GMT https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573657#M1103952 alexandros17 2014-04-14T14:12:05Z Re: Re: Formato de tabla pivotante https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573658#M1103953 <HTML><HEAD></HEAD><BODY><P>Thanks!! </P><P></P><P>I didn't know that I had to drag into the table...</P><P></P><P>I caught the idea of how to calculate the % column, but it is not well calculated...</P></BODY></HTML> Mon, 14 Apr 2014 14:40:29 GMT https://community.qlik.com/t5/QlikView/Formato-de-tabla-pivotante/m-p/573658#M1103953 2014-04-14T14:40:29Z