topic Re: Is it possible to hide expression in pivot table? in QlikView

Is it possible to hide expression in pivot table?

sushil353 — Tue, 29 Nov 2011 05:04:40 GMT

Hi All,

I am using a pivot table in fully expanded mode. and i want to hide the expression calculated.

i am using qlikview 10 SR3.

Please share your experience to solve this problem. please have a look in the screen shot given below.

Thanks

Sushil

Is it possible to hide expression in pivot table?

rohit214 — Tue, 29 Nov 2011 06:56:56 GMT

hi sushil

put =' in label so you can't able to see your expression

may it helps you

thanks

rohit

Re: Is it possible to hide expression in pivot table?

Sokkorn — Tue, 29 Nov 2011 07:17:57 GMT

Hi Sushil,

You cannot hide expression in pivot table for QlikView v.10. This feature is available with QlikView version 11. I have one idea, but maybe cannot apply to your issue. Solution is disable or enable desire expression through module.

Here is the sample:

SUB EnableExp1
    SET chart = ActiveDocument.GetSheetObject("CH39")
    SET cp = chart.GetProperties
    SET expr = cp.Expressions.Item(0).Item(0).Data.ExpressionData
    expr.Enable = TRUE 'Enable First expression
    chart.SetProperties cp
END SUB
SUB DisableExp1
    SET chart = ActiveDocument.GetSheetObject("CH39")
    SET cp = chart.GetProperties
    SET expr = cp.Expressions.Item(0).Item(0).Data.ExpressionData
    expr.Enable = FALSE 'Disable First expression
    chart.SetProperties cp
END SUB

Let me know if this one help you.

Regards,

Sokkorn

Is it possible to hide expression in pivot table?

jagan — Tue, 29 Nov 2011 07:25:46 GMT

Hi Sushil,

I think there is no such option for Pivot table, but we can do this Straight table but that wouldn't serves your purpose. The only thing we do is, give a single space for Expression label and set Expression column width to 0 by manually dragging.

Regards,

Jagan.

Re: Is it possible to hide expression in pivot table?

Wed, 20 Aug 2014 05:46:29 GMT

Yes, It is. Go to Expression tab -> select desired expression -> uncheck Enable check box. It worked for me. Hope it helps.

Re: Is it possible to hide expression in pivot table?

Fri, 06 Mar 2015 07:51:09 GMT

Hi Sokkorn,

Is there any way to set the width of first expression.

Thanks

Re: Is it possible to hide expression in pivot table?

Fri, 06 Mar 2015 07:53:41 GMT

Hi Jagan,

I am trying to hide the first expression by using. can you please tell me how to identity the first expression in pivot chart.

SUB DisableExp1

SET chart = ActiveDocument.GetSheetObject("CH67")

SET cp = chart.GetProperties

SET expr = cp.Expressions.Item(0).Item(0).Data.ExpressionData

expr.Enable = True 'Disable First expression

chart.SetProperties cp

END SUB

Re: Is it possible to hide expression in pivot table?

Thu, 06 Apr 2017 13:44:07 GMT

Create a random expression and uncheck 'Enable' in the expressions tab.

Re: Is it possible to hide expression in pivot table?

Anonymous — Wed, 31 Oct 2018 19:21:41 GMT

create an expression with one single space as label.

Then, you might have created some filter criteria in the expression, But your don't want to see that column in the pivot table I believe.

If above is the case : create your condition in the expression.

for example. if( count({< TLM = {"NEW"} >} Appications) > 0 ,'','')

that fixes you hiding issue.