Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Repeat row labels in dimensions in pivot

Hi,

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.

Does anybody know how to do this?

Best regards,

Claus

4 Replies
Not applicable

Re: Repeat row labels in dimensions in pivot

Changing the Pivot to a straight table should do the trick...

Highlighted
Not applicable

Re: Repeat row labels in dimensions in pivot

Hi Pravesh,

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?

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).

Highlighted
Not applicable

Re: Repeat row labels in dimensions in pivot

Yeah, have come across this before. Have you tried sorting by the accumulated expression as well?

Highlighted
Not applicable

Re: Repeat row labels in dimensions in pivot

Hi Pravesh,

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.

Do you know of any other way to solve it?