topic Is it possible to hide expressions? in QlikView

Is it possible to hide expressions?

Tue, 18 Oct 2011 09:32:10 GMT

I need to hide an expression from being published, but as its linked to formula it still needs to form a basis for the report.

Un-checking the' Enable' button in the expressions tab removes it from the report completly , all I want to do is hide it & for formula still to be calculated from data in this expression.

Is this possible ?

Is it possible to hide expressions?

jagannalla — Tue, 18 Oct 2011 09:55:35 GMT

Yes it is possible.. may i know which object you are using.

For eg:

With straight table we can hide expression using calculations.

Presentaion Tab -> select your expression -> Click on Condition radio button and give u r calculation.

Is it possible to hide expressions?

Tue, 18 Oct 2011 09:59:51 GMT

Thanks

Im using a Pivot table, is this still possible to hide?

Is it possible to hide expressions?

jagannalla — Tue, 18 Oct 2011 10:08:24 GMT

No it is not possible with Pivot table..Shift to straight table and use it.

Re: Is it possible to hide expressions?

Sokkorn — Tue, 18 Oct 2011 10:12:48 GMT

I think this one is not available yet in Pivot Tables. But we still can do it with these solution:

1. Use a text color Dimensions to make the text same color as backgound.

2. Macro:

SUB HideDimension

SET ch = ActiveDocument.GetSheetObject("CH01")

ch.SetPixWidth 0, 0

END SUB

Hope this help.

Regards,

Sokkorn

Is it possible to hide expressions?

Anonymous — Tue, 18 Oct 2011 11:02:35 GMT

I am not sure if you can use this but I sometimes set the calculations in the hidden script, like:

LET v_Profit = 'SUM(SALES) - SUM(COSTS)'

Then you can use : $(v_Profit) as your expression.

Hope it is helpfull.

Dennis.