topic Re: Hide column in pivot table during the presentation in QlikView

Hide column in pivot table during the presentation

Sat, 09 Aug 2014 14:17:17 GMT

Hello,

I need Hide column in pivot table, for this presentation.

I need hide column Producción only

helpme please

Re: Hide column in pivot table during the presentation

Anonymous — Sat, 09 Aug 2014 14:35:27 GMT

Expressions, like your one for the Producción column, can be set to Conditional on your object Expression tab and then a condition defined which will mean the expression is only displayed when this condition is met.

Thus one could then check in this condition expression a variable to only show the column if it it set to say 'Show'. The variable itself could be adjusted in an Input Box or by an Action on a Button / Text Box.

Re: Hide column in pivot table during the presentation

Sat, 09 Aug 2014 21:24:12 GMT

In the column(Expression) set the Text Color to white() and you can resize the column. The column is still there but the text color and the cell color will be same and won't be visible to the user.

Regs

Ram

Re: Hide column in pivot table during the presentation

aveeeeeee7en — Sat, 09 Aug 2014 22:18:00 GMT

Hi Rolando

You can use Conditional Hide (Enable condition) and pass any wrong condition like 1>1. It will hide the Column.

Select Producción column which you want to hide - I do't know whether Producción column is your dimension or expression. Check the enable contion option and write the above condition (1>1) for Producción column.

See the snapshot:

Hope that helps you.

Regards

Aviral Nag