topic Re: Re: Pivot table - hide columns in QlikView

Pivot table - hide columns

Thu, 10 Jul 2014 09:21:06 GMT

Hi All,

How to hide columns in pivot table

I have wave1 and wave2 columns and i have to hide wave1 columns other than total column at Column level.

Please help.

Re: Pivot table - hide columns

datanibbler — Thu, 10 Jul 2014 09:23:28 GMT

Hi,

on the "presentation" tab, you can select any of your columns and there are radio_buttons to show or hide or conditionally show the columns.

Re: Pivot table - hide columns

ashfaq_haseeb — Thu, 10 Jul 2014 09:40:13 GMT

Hi,

You cannot hide columns in pivot table.

You can set width to zero.

look at the below post.

http://community.qlik.com/thread/67354

http://community.qlik.com/message/445835#445835

Regards

ASHFAQ

Re: Pivot table - hide columns

aveeeeeee7en — Thu, 10 Jul 2014 09:41:24 GMT

Hi SelvaDXB

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

Select particular which you want to hide and write this condition.

Hope that works for you.

See the Attchments.

Regards

Aviral Nag

Re: Re: Pivot table - hide columns

Thu, 10 Jul 2014 09:55:51 GMT

Hi All,

I tried and it couldn't do.

I have attached my QV file. Please help.

Thanks

Re: Re: Re: Pivot table - hide columns

sudeepkm — Thu, 10 Jul 2014 10:22:30 GMT

I do not think it is possible in one table but you can use two table over layered to achieve this.

The table alignment has to be done carefully to accept all sorts of filter selections.

Re: Pivot table - hide columns

Thu, 10 Jul 2014 10:30:33 GMT

Expression-->Select the expression u want to hide--> tick conditional-->Give your condition

Re: Re: Re: Pivot table - hide columns

aveeeeeee7en — Thu, 10 Jul 2014 10:31:31 GMT

See the Attachment.

Re: Re: Pivot table - hide columns

Thu, 10 Jul 2014 12:21:40 GMT

Thanks a lot sudeepkm

Re: Re: Pivot table - hide columns

Thu, 10 Jul 2014 12:22:12 GMT

Thanks a lot Aveeeeeee7en

Re: Re: Re: Re: Pivot table - hide columns

Mon, 14 Jul 2014 10:06:45 GMT

Hi,

I am facing issue with null. below is my expression.

if ( sum(Alt(Value,0)) = 1 , Dual('Yes',1) , if ( sum(Alt(Value,0)) = 0 , Dual('No',0) , sum(Alt(Value,0))))

I need to check if the value is null then i have to display as 'N/A'.

Please help.

Thanks.