topic Re: Pivot table dimension labels in QlikView

Pivot table dimension labels

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

How do I change the position of the label on the second dimension of the following pivot table. I would like to remove it or have it appear above -

Anil_Babu_Samineni — Wed, 23 Nov 2016 13:39:59 GMT

I Assume, you may have done with Cross Table. So, I Would read to suggest you to create flag

Load *, 'Region' as Region

From <Source>;

Then, Use this Direct for dim and try transpose

OR else

Another way is You can create calc dim like ValueList('Region') and then use like above

rupamjyotidas — Wed, 23 Nov 2016 14:21:40 GMT

Follow what Anil Has suggested, There is a simple solution to remove it. Rename it in the Label Section.

Instead of Region just put <Space Bar>.

sunny_talwar — Wed, 23 Nov 2016 14:24:58 GMT

You can add a third dimension between your two dimensions like this

Local_authority

'Region' -> New Dimension with only text Region

Region

Then pivot the 2nd and 3rd dimension by dragging them to the top