Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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?