Hiding columns in a pivot table

[tmumaw]

Hi All,

I am trying to hide columns in a pivot table.  We are on V11 and I was told I could do this using conditions, but have yet to go down that route.  I have What-if columns that I do not want to display, but want the results in the last two columns.  Help.  Thanks

[salto]

Hello,

you can hide / unhide the columns in a pivot table by enabling / disabling the "conditional" checkbox in the "Expressiones" tab of the pivot table, and writing a condition in the box below the checkbox.

Hope this helps.

[tmumaw]

I want to be able to use the column though in the columns labeled "What If" and Results (YTD).  Not too sure how to use the conditions to achieve this.

[salto · Accepted solution]

Just keep the value "Conditional" unchecked in those two columns, and enable it the rest of columns. In the condition box, write something that will always be false (1>1 will do for example).

[tmumaw]

Thanks SALTO....That was exactly what I wanted ot do.

[salto]

I am glad it worked! Don't forget to mark the answer as correct - it may help other users.

Regards.

El 22/10/2013, a las 16:34, Thom Mumaw <qcwebmaster@qlik.com> escribió:

QlikCommunity

Hiding columns in a pivot table

reply from Thom Mumaw in Layout & Visualizations - View the full discussion

Thanks SALTO....That was exactly what I wanted ot do.

Reply to this message by replying to this email, or go to the message on QlikCommunity

Start a new discussion in Layout & Visualizations by email or at QlikCommunity

Following Hiding columns in a pivot table in these streams: Inbox

© 1993-2013 QlikTech International AB Copyright & Trademarks | Privacy | Terms of Use | Software EULA

[jarno_loubser]

Perhaps I am missing the objective here (or my objective is different), but I would like to know how to Hide an Expression without Disabling it in a pivot table.

When you use the conditional tick (and expression) on an expression to "disable" it the Expression can no longer be used as a input result in other expressions.

Let's say I have CurrencyRate expression - the value of which I use in 5 other expressions, but I do not want to show the CurrentRate expression.

All this in a Pivot table - any ideas?

[stantrolav]

Write =False() in condition. All Expressions would count for this hided dimension as well.