topic Re: Repeat row labels in dimensions in pivot in QlikView https://community.qlik.com/t5/QlikView/Repeat-row-labels-in-dimensions-in-pivot/m-p/1114761#M902054 <HTML><HEAD></HEAD><BODY><P>Hi Pravesh,</P><P></P><P>If I do that, then I have the issue that one of my columns is an accumulated rolling sum of another column, but when I make it a straight table, I fixes the sorting of the table so that I cannot sort by the columns I want. Instead, it just sorts by the name of the first dimension. Have you ever encountered this issue?</P><P></P><P>That was the reason I changed it to a pivot table, because somehow, that allowed me to sort by expression. The straight table seemed to ignore the sort expression, until i removed the accumulated sum column (its a "rangesum(above(sum(" method).</P></BODY></HTML> Fri, 08 Jul 2016 08:04:01 GMT 2016-07-08T08:04:01Z Repeat row labels in dimensions in pivot https://community.qlik.com/t5/QlikView/Repeat-row-labels-in-dimensions-in-pivot/m-p/1114759#M902052 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am having an issue where I am not able to repeat the row names of dimensions, so that it mentions each label multiple times in the dimension column.</P><P></P><P>Does anybody know how to do this?</P><P></P><P>Best regards,</P><P>Claus</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Repeat-row-labels-in-dimensions-in-pivot/m-p/1114759#M902052 2020-11-25T16:16:04Z Re: Repeat row labels in dimensions in pivot https://community.qlik.com/t5/QlikView/Repeat-row-labels-in-dimensions-in-pivot/m-p/1114760#M902053 <HTML><HEAD></HEAD><BODY><P>Changing the Pivot to a straight table should do the trick...</P></BODY></HTML> Fri, 08 Jul 2016 07:55:04 GMT https://community.qlik.com/t5/QlikView/Repeat-row-labels-in-dimensions-in-pivot/m-p/1114760#M902053 2016-07-08T07:55:04Z Re: Repeat row labels in dimensions in pivot https://community.qlik.com/t5/QlikView/Repeat-row-labels-in-dimensions-in-pivot/m-p/1114761#M902054 <HTML><HEAD></HEAD><BODY><P>Hi Pravesh,</P><P></P><P>If I do that, then I have the issue that one of my columns is an accumulated rolling sum of another column, but when I make it a straight table, I fixes the sorting of the table so that I cannot sort by the columns I want. Instead, it just sorts by the name of the first dimension. Have you ever encountered this issue?</P><P></P><P>That was the reason I changed it to a pivot table, because somehow, that allowed me to sort by expression. The straight table seemed to ignore the sort expression, until i removed the accumulated sum column (its a "rangesum(above(sum(" method).</P></BODY></HTML> Fri, 08 Jul 2016 08:04:01 GMT https://community.qlik.com/t5/QlikView/Repeat-row-labels-in-dimensions-in-pivot/m-p/1114761#M902054 2016-07-08T08:04:01Z Re: Repeat row labels in dimensions in pivot https://community.qlik.com/t5/QlikView/Repeat-row-labels-in-dimensions-in-pivot/m-p/1114762#M902056 <HTML><HEAD></HEAD><BODY><P>Yeah, have come across this before. Have you tried sorting by the accumulated expression as well?</P></BODY></HTML> Fri, 08 Jul 2016 10:18:54 GMT https://community.qlik.com/t5/QlikView/Repeat-row-labels-in-dimensions-in-pivot/m-p/1114762#M902056 2016-07-08T10:18:54Z Re: Repeat row labels in dimensions in pivot https://community.qlik.com/t5/QlikView/Repeat-row-labels-in-dimensions-in-pivot/m-p/1114763#M902058 <HTML><HEAD></HEAD><BODY><P>Hi Pravesh,</P><P></P><P>Yes I tried that, but it is almost like the sorting is locked after the Rangesum( column is introduced... Not sure what is going wrong.</P><P></P><P>Do you know of any other way to solve it?</P></BODY></HTML> Fri, 08 Jul 2016 11:44:18 GMT https://community.qlik.com/t5/QlikView/Repeat-row-labels-in-dimensions-in-pivot/m-p/1114763#M902058 2016-07-08T11:44:18Z