topic Re: Hide column in Pivot table in QlikView

Hide column in Pivot table

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

Hi All,

I have the below Pivot table where I have generated dates which isn't available in my DB. The row is getting added(in here 10/19/2017) along with a column full of 0's. Is there a way to hide the column with 0's alone?

Cdate/LOB	Manual	Auto	Referred
10/21/2017	10	0	0	0
10/20/2017	10	35	0	0
10/19/2017	0	0	0	0
10/18/2017	67	6	6	0
10/17/2017	0	78	0	0
10/16/2017	89	0	8	0

I did find this macro which says that we can hide the colum . Could you please let me know how exactly this works? or is there any other way?

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

Any help will be much appreciated.

Thanks,

Anupama Jagan

Re: Hide column in Pivot table

MarcoARaymundo — Sat, 21 Oct 2017 13:51:27 GMT

Hi! this not possible

Re: Hide column in Pivot table

atoz1158 — Sat, 21 Oct 2017 14:04:56 GMT

You cannot hide a column in a Pivot Table as you can in a Straight Table, if you do not need to use a Pivot Table converted it into a Straight Table and then on the Presentation tab for the table properties you will have an option to Hide the Column.

The best you can do in a Pivot Table is to set the background and foreground colours to be the same for that column and make its width as small as possible.

Regards

Adrian

Re: Hide column in Pivot table

Anonymous — Sat, 21 Oct 2017 14:17:51 GMT

But how to change the colour and width for that column alone? because its doesn't have any LOB attached to it. It just pops up only cos I have generated the missing dates ...

Re: Hide column in Pivot table

Anil_Babu_Samineni — Sat, 21 Oct 2017 14:28:00 GMT

Does this macro using any button?

Re: Hide column in Pivot table

Anonymous — Sat, 21 Oct 2017 14:30:24 GMT

I don't have any information regarding this macro. When I searched for this problem in this below link..

Pivot Column Width to Zero

Re: Hide column in Pivot table

MarcoARaymundo — Sat, 21 Oct 2017 14:30:46 GMT

There is no width control per column, even though the column does not have zero width.

You can change the color to the same from the background.

Re: Hide column in Pivot table

Anil_Babu_Samineni — Sat, 21 Oct 2017 14:42:30 GMT

Would you like to go macro code using button in extra object?

Re: Hide column in Pivot table

Anonymous — Sat, 21 Oct 2017 18:40:55 GMT

Is it not possible otherwise? because the requirement is on opening the document the table should all dates but without that extra 0 column..

Re: Hide column in Pivot table

pradosh_thakur — Sat, 21 Oct 2017 20:33:04 GMT

Well there is a possibility. Give it a try.

1: go to the expression for that column

2: check conditional show

3: set condition 1=0

regards

Pradosh

Re: Hide column in Pivot table

uroboros — Sat, 21 Oct 2017 20:46:45 GMT

You can use design options to realize this goal. Like a report adhoc, look instead

What is Ad hoc reports in Qlikview?

Re: Hide column in Pivot table

Anonymous — Sun, 22 Oct 2017 05:47:51 GMT

But this column with 0's is populated because of the missing dates im generating. It doesn't have any expression attached to it.

Re: Hide column in Pivot table

pradosh_thakur — Sun, 22 Oct 2017 05:51:13 GMT

post the sample app .

regards

Pradosh

Re: Hide column in Pivot table

vinieme12 — Sun, 22 Oct 2017 06:19:06 GMT

I would suggest you use a calculation condition for that column something like below

=if(total for referred expression > 0 ,1,0) // show the expression if there is atleast one non zero value else hide expression

The macro only reduces the column width, which means it's still there ...just not visible!

Re: Hide column in Pivot table

Anil_Babu_Samineni — Sun, 22 Oct 2017 09:09:13 GMT

Can you explain little more is about povit table and when you need to open the document you are good to hide one specific column. I believe this may possible here..

Re: Hide column in Pivot table

Anonymous — Sun, 22 Oct 2017 10:58:10 GMT

This pivot table is shown when we open the application itself .this is the first tab.

The pivot table without generating the missing dates will be like this:

Cdate/LOB	Manual	Auto	Referred
10/21/2017	10	0	0
10/20/2017	10	35	0
10/18/2017	67	6	6
10/17/2017	0	78	0
10/16/2017	89	0	8

But after generating the missing date which is 10/19/2017 im getting an extra column with 0's

Cdate/LOB	Manual	Auto	Referred
10/21/2017	10	0	0	0
10/20/2017	10	35	0	0
10/19/2017	0	0	0	0
10/18/2017	67	6	6	0
10/17/2017	0	78	0	0
10/16/2017	89	0	8	0

Re: Hide column in Pivot table

Anil_Babu_Samineni — Sun, 22 Oct 2017 11:06:54 GMT

So, that means when you suppress from presentation tab what will be the report

Re: Hide column in Pivot table

Anonymous — Sun, 22 Oct 2017 11:12:49 GMT

when we suppress zeros from Presentation tab it takes out the 0's rows also..

I need to have the row with zeros ( in the above table 10/19/2017) but need to remove the 0's column ( after the referred column)

Manual ,Auto, Referred are all LOB's

Re: Hide column in Pivot table

Anil_Babu_Samineni — Sun, 22 Oct 2017 11:16:05 GMT

Tri to enable the condition for all metrics line

If(manual exp >0, 0,1)

If(auto exp >0, 0,1)

If(referred exp >0, 0,1)

Re: Hide column in Pivot table

Anonymous — Sun, 22 Oct 2017 11:19:55 GMT

Actually my expression is only one:

sum(Subs)

In dimension I have Date and LOB

I have dragged the LOB to the top to show sum per LOB