Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have requirement to create a pivot table in Qlik Sense with a dimension and couple of measures to be added as dimensions (synthetic dimensions) by aggr with that dimension to show them freeze while scrolling the horizontally.
The problem is, I also need to show totals row for the synthetic dimensions as well like in excel. Is there any solution for this?
@Michael_Tarallo @sunny_talwar
Hi, I don't think there is an exact solution for this using the standard objects, as a workaround you can set the reference visible calculating it in title, subtitle, footnote or in the same totals row changing the dfualt 'Totals' text to add the totals expression for this dimension, but in this case it will be shown on the left, not in the same column of the other values of that dimension but at least you kept the reference value in the same row as the other measures.
Thaks @rubenmarin for responding. Is there any alternate way where we can add them as measures in the pivot table but can freeze those columns so that they will not move as we scroll?
Hi, I don't know a way to do that, even the totals columns are displaced.
The nearest approach may be to use n objects on top of each other / side by side with/without some overlapping (no idea if there are already inbuilt features or extensions - but it's html and per css z-level manipulating it should be possible) and/or within containers.