topic How to create a Link expression in Pivot Tables? in QlikView https://community.qlik.com/t5/QlikView/How-to-create-a-Link-expression-in-Pivot-Tables/m-p/1289827#M403468 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am creating a link expression in a pivot table, and it's not working. In the straight table works perfectly, but I will need that the fields are being grouped by family - first, then type, code and sub-code. The link expression will be in the code. For example:</P><P></P><P>Wood tools &gt;Hand &gt;1223 &gt;1</P><P>Wood tools &gt;Hand &gt;1223 &gt;2</P><P>Wood tools &gt;Hand &gt;1223 &gt;3</P><P></P><P>In a straight table you will have one row per record, but in the pivot table you will have only</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>Wood tools &gt;Hand &gt;1223 &gt;2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P></P><P>I will like to have the code in a link expression, instead of have it that way I will have something like:</P><P>Wood tools &gt;Hand &gt;code &gt;1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; total</P><P>Wood tools &gt;Hand &gt;code&gt;2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; total</P><P>Wood tools &gt;Hand &gt;code&gt;3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; total</P><P></P><P>Any idea on how to do it?</P></BODY></HTML> Fri, 03 Feb 2017 13:38:38 GMT Anonymous 2017-02-03T13:38:38Z How to create a Link expression in Pivot Tables? https://community.qlik.com/t5/QlikView/How-to-create-a-Link-expression-in-Pivot-Tables/m-p/1289827#M403468 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am creating a link expression in a pivot table, and it's not working. In the straight table works perfectly, but I will need that the fields are being grouped by family - first, then type, code and sub-code. The link expression will be in the code. For example:</P><P></P><P>Wood tools &gt;Hand &gt;1223 &gt;1</P><P>Wood tools &gt;Hand &gt;1223 &gt;2</P><P>Wood tools &gt;Hand &gt;1223 &gt;3</P><P></P><P>In a straight table you will have one row per record, but in the pivot table you will have only</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>Wood tools &gt;Hand &gt;1223 &gt;2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P></P><P>I will like to have the code in a link expression, instead of have it that way I will have something like:</P><P>Wood tools &gt;Hand &gt;code &gt;1</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; total</P><P>Wood tools &gt;Hand &gt;code&gt;2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; total</P><P>Wood tools &gt;Hand &gt;code&gt;3</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; total</P><P></P><P>Any idea on how to do it?</P></BODY></HTML> Fri, 03 Feb 2017 13:38:38 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Link-expression-in-Pivot-Tables/m-p/1289827#M403468 Anonymous 2017-02-03T13:38:38Z Re: How to create a Link expression in Pivot Tables? https://community.qlik.com/t5/QlikView/How-to-create-a-Link-expression-in-Pivot-Tables/m-p/1289828#M403469 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>use partial sums here</P><P><IMG alt="partialsums.GIF" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/151920_partialsums.GIF" style="width: 620px; height: 259px;" /></P></BODY></HTML> Fri, 03 Feb 2017 14:03:22 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Link-expression-in-Pivot-Tables/m-p/1289828#M403469 stabben23 2017-02-03T14:03:22Z Re: How to create a Link expression in Pivot Tables? https://community.qlik.com/t5/QlikView/How-to-create-a-Link-expression-in-Pivot-Tables/m-p/1289829#M403470 <HTML><HEAD></HEAD><BODY><P>I did it, but this is what I am getting:</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/151926_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Fri, 03 Feb 2017 15:17:40 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Link-expression-in-Pivot-Tables/m-p/1289829#M403470 Anonymous 2017-02-03T15:17:40Z Re: How to create a Link expression in Pivot Tables? https://community.qlik.com/t5/QlikView/How-to-create-a-Link-expression-in-Pivot-Tables/m-p/1289830#M403471 <HTML><HEAD></HEAD><BODY><P>I need instead of URL and Total, get the value with the link to access it. </P></BODY></HTML> Fri, 03 Feb 2017 15:28:29 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Link-expression-in-Pivot-Tables/m-p/1289830#M403471 Anonymous 2017-02-03T15:28:29Z