topic Re: How to hide a column in a pivot table in QlikView

How to hide a column in a pivot table

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

Hello,

I have read a number of discussions about this same topic on tricks to hide columns in a pivot table using conditional show on the expression or changing the background colour on the expression to ARGB(0,0,0,0) and then shrinking the column size.

I have a pivot table where I am calculating Percentages of Manual & Non-Manual Appointments. As shown below.

The user requirement is to hide the Manual percentage column and only show the Non-manual Percentages.

The expression which provides the Percentages is as follows:

Num(count({<[Type]>}DS_ID)/Count(TOTAL<Producttype,MthNameCreated_dt,DSWeek,DSCreated> DS_ID), '#,##0.00%')

I have tried a conditional show on the expression as shown below

if([Type]='Manual',Null(),Num(count({<[Type]>}DS_ID)/Count(TOTAL<Producttype,MthNameCreated_dt,DSWeek,DSCreated> DS_ID), '#,##0.00%'))

The results shown below is what I get.

I want to hide the Percentages Manual column circled in diagram below.

Any ideas?

Re: How to hide a column in a pivot table

Anil_Babu_Samineni — Thu, 22 Jun 2017 16:21:46 GMT

Will you able to share sample application

Re: How to hide a column in a pivot table

Anonymous — Thu, 22 Jun 2017 16:24:46 GMT

when using manual / non manual as a dimension and use only 1 expression it is possible.

Search for concatenated fact table.

Re: How to hide a column in a pivot table

gallantabs — Fri, 23 Jun 2017 12:33:30 GMT

Thank you Anil for your response.

I have tweaked your suggestion slightly and have attached a sample version of the application with the pivot table and some data.

The requirement is for the expression called Percentage to show values for Non-Manual only and hide the Manual Percentage.

Re: How to hide a column in a pivot table

gallantabs — Fri, 23 Jun 2017 12:38:23 GMT

Thank you for your update.

I will search for your suggestion and try it out.

Re: How to hide a column in a pivot table

Anil_Babu_Samineni — Fri, 23 Jun 2017 16:01:49 GMT

You want to suppress only for Jan-2017?? Or where Manual is Null we need to remove those in your report?

Re: How to hide a column in a pivot table

gallantabs — Fri, 23 Jun 2017 16:14:41 GMT

Hi Anil,

I want to suppress for all. Remove the Manual column under percentages, so they are not showing on the report.

Thnx

Re: How to hide a column in a pivot table

Peter_Cammaert — Fri, 23 Jun 2017 16:50:41 GMT

Or you could try creating an artificial dimension (with values 'Manual', 'Non-Manual') using the ValueList() function, and thereby activating the Suppress when Value is 0/NULL feature of other table objects.

For an explanation with examples, see here: Re: How to hide a entire column where fields are empty/null.