topic Re: How to hide an expression in pivot table? in QlikView

How to hide an expression in pivot table?

Wed, 12 Mar 2014 14:37:05 GMT

I have few expressions in the pivot table but i don't want to show the values of all. I just need a way to hide the expression and i can use that hidden expression column in calculating another expression. Find the attachment for the example. How can i hide an expression in pivot table but still use in calculating another expression?

Exp1 (hidden)	Exp2 (hidden)	Exp3=Column(2)-Column(1)

The way i am trying to do this is for the expression(Exp3) using the columns from previous expressions which should be hidden.

Re: How to hide an expression in pivot table?

alexandros17 — Wed, 12 Mar 2014 14:41:27 GMT

here it is

Re: How to hide an expression in pivot table?

PrashantSangle — Wed, 12 Mar 2014 14:45:00 GMT

Hi,

Goto Chart properties-> Expression->Enable(uncheck)

It will solve your problem..

Re: How to hide an expression in pivot table?

Wed, 12 Mar 2014 14:49:23 GMT

Thanks for the input.

But,this one does serve the purpose to hide the expression, but in this case i need to hide the expression but still need to use that column to calculate another expression?

Re: How to hide an expression in pivot table?

Wed, 12 Mar 2014 14:54:24 GMT

If we uncheck, which means it does disable the expression and that is not going to work in this situation.

Re: How to hide an expression in pivot table?

sudeepkm — Wed, 12 Mar 2014 14:59:16 GMT

I think you can achieve that in a straight table using hide column.

Re: How to hide an expression in pivot table?

PrashantSangle — Wed, 12 Mar 2014 14:59:20 GMT

Hi,

Go to Presentation tab

Select Your Expression->check(Hide Column)

Re: How to hide an expression in pivot table?

alexandros17 — Wed, 12 Mar 2014 15:01:32 GMT

In pivot that is the only way, otherways select straight table

Re: How to hide an expression in pivot table?

Wed, 12 Mar 2014 15:04:05 GMT

Yes, but i would need to use the pivot table rather than straight table to show the grouping view.

Re: How to hide an expression in pivot table?

sudeepkm — Wed, 12 Mar 2014 15:05:32 GMT

Workaround in Pivot table.

Re: How to hide an expression in pivot table?

Anonymous — Wed, 12 Mar 2014 15:06:57 GMT

one way is that you can make the background color and text color of the expression the same and make that column as small as possible...just like Sudeep showed. I guess we were typing at the same time!

Re: How to hide an expression in pivot table?

Wed, 12 Mar 2014 15:07:34 GMT

Hi,

Goto Chart properties-> Expression->Disable it(Uncheck the "Enable" CheckBox)

Re: How to hide an expression in pivot table?

Anonymous — Wed, 12 Mar 2014 15:08:39 GMT

in the above scenario if i am in your place i would create a straight table with the above solution given by Sundeep or else create variables for exp1 and exp2 and use them in the exp3 so you don't need to worry to hide them.

Re: How to hide an expression in pivot table?

PrashantSangle — Wed, 12 Mar 2014 15:18:28 GMT

Hi,

As said by Alexandros17 it is really not possible in pivot chart .

but you can use either of two solution

1st solution given by sudeepkm

2nd You can create a variable in that save your expression.

and use that variable in your pivot table.

try this.

Re: How to hide an expression in pivot table?

Wed, 12 Mar 2014 15:50:52 GMT

I think the closest i can get with this requirement is what Sudeep Mahapatra proposed. But, still to dreamer4 point creating a variable and using that in the expression is always an option. For me i would go with the first one.

I thought this would be helpful to share to anyone who will come across the same situation. So, if you try to implement by making the background color and text color similar which in this case you can almost make the column values invisible but when the user tries to export the pivot table to excel then the values of the column does show up in that case this might not be a idle solution. I hope there is a better way to do this.

Thanks for the Help

Re: How to hide an expression in pivot table?

Thu, 13 Mar 2014 07:58:04 GMT

Hi Dinesh,

Goto Chart properties select Pivot table in general-> Expression->Check Conditional, then below box gets activated. just give the condition else type 1=2.

Please check the below attached application

Re: How to hide an expression in pivot table?

Thu, 13 Mar 2014 16:20:04 GMT

By applying the condition 1=2 does hide the column but you cannot use the column for calculating another expression.