topic Hide column in pivot table in QlikView

Hide column in pivot table

Fri, 24 Dec 2010 07:24:57 GMT

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0243.Sample1.xls:550:0]In a Pivot table in the dimension there are tthree hierarchies ( say Field1 , Field2 and Field3 ). Field1 has sequence field ( say FieldSeq1) , similarly Field2 has sequence field (say FieldSeq2). We have to display the fileds sorted by first FieldSeq1 then FieldSeq2. But this sequence fields should not be displayed . Additionally Field3 should also not be displayed.

Till this point requirements matches with Straight tables. But we have some additional requirements where Straight table fails .

We need sub totals of two expresssion fields (exp1, exp2 say). Sub totals based on dimension Field3( though the column should be hidden), and same for Field1 and Field2. In the Sub Totals Row also we need Label with current Value of Field1, Field2 and Field3 respectively.

Attached is the format in which final report should be , but FieldSeq1, FieldSeq2 and Field3 columns should not be visible.

Please let me know if there is any solution like this.

Hide column in pivot table

Fri, 24 Dec 2010 10:36:13 GMT

Hiding columns in Pivot is not possible! In the properties of a pivot there is Tab for sorting by expression (FieldSeq1 then FieldSeq2), so maybe you can do it without these columns?

Hide column in pivot table

Fri, 24 Dec 2010 10:53:38 GMT

Hi,

Jochem is right.

You can try indent mode check box in style tab of pivot chart.

Hide column in pivot table

Fri, 24 Dec 2010 12:38:12 GMT

It solved the problems partially . Now FieldSeq1 and FieldSeq2 need not be selected in used dimension. Thanks to Jochem.

But How to eliminate the need of Field3 and also display subtotal labels dynamically shown in sample.

Hide column in pivot table

Anonymous — Sat, 25 Dec 2010 15:14:24 GMT

In fact, there is a way to hide columns in pivot - by setting columnwidth to 0. I often use this macro as a workaround:


sub Squeeze
 call HideColumn("CH01", 2)
end sub
'
private sub HideColumn(ch, n)
 set ch = ActiveDocument.GetSheetObject(ch)
 ch.SetPixWidth (n-1), 0
end sub

Hide column in pivot table

Sun, 26 Dec 2010 11:24:38 GMT

Check out this discussion:

http://community.qlik.com/forums/t/38417.aspx

Montal.

Hide column in pivot table

Mon, 27 Dec 2010 06:39:45 GMT

Thanks for the help Michael.

Finally Need to have the text in subtotals dynamically.

Hide column in pivot table

Tue, 28 Dec 2010 07:26:02 GMT

I had added the action in the trigger of onactive trigger of the sheet. But the macro is not getting triggered . When I'm pressing the test button of the macro it is getting executed.

Please suggest why the macro is not getting triggered ?

Addtionally in the label of partial sum, how the field values can be appended dynamically like it is shown in the attached file ?

Hide column in pivot table

Tue, 28 Dec 2010 14:23:40 GMT

try this, add this to your macro:

ActiveDocument.GetApplication.WaitForIdle

Hide column in pivot table

Wed, 29 Dec 2010 10:00:57 GMT

I have added the line at the begining of the macro but no improvement.

Additionally in terms of Sorting, in the Sort Tab for field3 I have made expression as checked and inside expression inputbox I have added the text "=FieldSeq1" but Field3 is still sorted alphabetically. Any further suggestion ?

Re: Hide column in pivot table

Mon, 29 Sep 2014 20:14:50 GMT

hello michale, im not really familiar with qlikview programing, could you be more specific on how this macro works. what is CH, what shall i replace if my column is called purpose for instance ... thanks

Re: Hide column in pivot table

Anonymous — Wed, 24 Jan 2018 07:38:23 GMT

Hi Michale ,

Is there any way in script or UI level not in Macro.

Re: Hide column in pivot table

satheshreddy — Wed, 24 Jan 2018 09:37:43 GMT

Hi MC,

if you want to perform Hide column and Show Column Please try to do using expression Tab Column conditional enable.

Regards

Sathesh

Re: Hide column in pivot table

petter — Wed, 24 Jan 2018 15:30:57 GMT

hmmmm .... you're trying to respond to a 7 year old thread - it should have been closed long ago...