topic Re: hide pivot column in QlikView

hide pivot column

felcar2013 — Mon, 29 Aug 2016 13:28:16 GMT

is there a way to hide a column in a Pivot table containing two dimensions (vertical and horizontal). With value list, it was not possible to hide the column. For example, for "member" i want to Display only, "Active 12 TY" and "New Members" but not "Reachability" or in General the ones with "0".

dimensions are "month" and "Status"

thanks

Felipe

Re: hide pivot column

Anonymous — Mon, 29 Aug 2016 13:46:13 GMT

calculated Dimension does not work?

if (match(member,'Active 12 TY',,'New Members')>0, member)

Re: hide pivot column

felcar2013 — Mon, 29 Aug 2016 13:54:33 GMT

hi, thanks, no, the Dimension is "Status". Member is value

Re: hide pivot column

jonas_rezende — Mon, 29 Aug 2016 14:02:42 GMT

Hi, Felipe Carrera.

Try the following steps:

1. Click with right-button on object chart pivot table;

2. In aba Presentation mark Suppress Zero-Values;

3. Click Ok.

Hope this helps!

Re: hide pivot column

Anonymous — Mon, 29 Aug 2016 14:03:20 GMT

I suppose that's not possible to suppress special columns like 'Active 12 TY' for Special dimensions like members but for others to Show them

you can only disable/enable columns completely (Show them for all values of your Dimension or none)

Re: hide pivot column

felcar2013 — Mon, 29 Aug 2016 14:08:56 GMT

hi, i loaded a test file

under month, i have several months

Re: hide pivot column

felcar2013 — Mon, 29 Aug 2016 15:22:59 GMT

i added data and an app, it seem it is not possible to hide columns, any other ideas?

thanks

Re: hide pivot column

felcar2013 — Tue, 30 Aug 2016 09:52:39 GMT

hi Jonas, thanks, this is good for a Dimension value, where there is not Expression value (or "0").

Finally i used several straight tables, and tried to get the form i Need, this works, as it is possible to hide the Dimension, without loosing the values in it