topic Re: Remove pivoting dimension header label. in QlikView

Remove pivoting dimension header label.

agni_gold — Tue, 29 Aug 2017 15:36:12 GMT

Hi Friends,

I have one situation,

I have one pivot table and also done pivoting over year dimension and made its label as blank, not I don't want that small square which is coming below in screenshot,

Any help

as it is ad-hoc reporting so that I cannot put a text box over it ., Attaching sample file

Re: Remove pivoting dimension header label.

vinieme12 — Tue, 29 Aug 2017 15:49:22 GMT

Not Possible

Re: Remove pivoting dimension header label.

vishsaggi — Tue, 29 Aug 2017 16:13:04 GMT

May be you can try to squeeze that column using a Macro.

Ref From: Hide column in pivot table

Press Ctrl+M

Then copy paste this code

sub Squeeze

call HideColumn("CH01", 3)

end sub

private sub HideColumn(ch, n)

set ch = ActiveDocument.GetSheetObject(ch)

ch.SetPixWidth (n-1), 0

end sub

Re: Remove pivoting dimension header label.

agni_gold — Tue, 29 Aug 2017 16:14:51 GMT

Thanks,

But can we remove it without Macro ?

Re: Remove pivoting dimension header label.

vishsaggi — Tue, 29 Aug 2017 16:24:01 GMT

Not possible. However, this is just a one time macro to run. Once you run this macro you can delete the macro and save it.

Re: Remove pivoting dimension header label.

agni_gold — Tue, 29 Aug 2017 16:48:15 GMT

At the time of deployment should i need that macro also ?

means while publishing to browser ?

Re: Remove pivoting dimension header label.

vishsaggi — Tue, 29 Aug 2017 16:51:08 GMT

Once you save it, it should be fine when you deploy to PROD.

Re: Remove pivoting dimension header label.

agni_gold — Tue, 29 Aug 2017 16:53:29 GMT

and my table is pivot , and ad hoc reporting done on that , now when i am runnig this maro on my app , it is not removing that sqare , it is making closure my other columns

Re: Remove pivoting dimension header label.

vishsaggi — Tue, 29 Aug 2017 16:57:13 GMT

Did not get you. In your pivot you sent you want 3rd column to be squeezed. So in your original pivot table you should figure out which column should be squeezed. Like change here:

3 here is like 3rd dimension column. If it is a 2nd or 4th column just replace 3 with that dimension order.

sub Squeeze

call HideColumn("CH01", 3)

end sub

private sub HideColumn(ch, n)

set ch = ActiveDocument.GetSheetObject(ch)

ch.SetPixWidth (n-1), 0

end sub

Re: Remove pivoting dimension header label.

agni_gold — Tue, 29 Aug 2017 16:59:58 GMT

Correct , as i have already changed that , to my last column but i have done pivoting on that dimension , so that it is squeezing my data column not label , i want just to remove label, can you please share that file in which you have checked ?

Re: Remove pivoting dimension header label.

vishsaggi — Tue, 29 Aug 2017 17:11:51 GMT

This is your actual qvw file i worked on. See attached.

Re: Remove pivoting dimension header label.

agni_gold — Tue, 29 Aug 2017 19:37:54 GMT

But when i send it to excel but column C is still there .

Re: Remove pivoting dimension header label.

vishsaggi — Tue, 29 Aug 2017 19:59:23 GMT

Thats what we said it is not possible to completely remove it because in your pivot you are using field Year which displays 2013, 2014 etc. So when you export to excel the column C will be suppressed mode. You can just delete that column once you export to excel as an alternative.