Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi sushil
put =' in label so you can't able to see your expression
may it helps you
thanks
rohit
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
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.
Yes, It is. Go to Expression tab -> select desired expression -> uncheck Enable check box. It worked for me. Hope it helps.
Hi Sokkorn,
Is there any way to set the width of first expression.
Thanks
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
Create a random expression and uncheck 'Enable' in the expressions tab.
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.