Is it possible to hide expression in pivot table?

[sushil353]

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

[rohit214]

hi sushil

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

may it helps you

thanks

rohit

[Sokkorn]

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

[jagan]

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.

[#5]

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

[#6]

Hi Sokkorn,

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

Thanks

[#7]

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

[#8]

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

[Anonymous]

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.