Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional hiding formulas in pivot tables

Hello,

according to http://community.qlik.com/ideas/2084 in QV 11 it should be possible to hide formulas in pivot tables with these formulas beeing calculated.

I have severeal formulas in my pivot table using theses to calculate a new formula. But I want to hide the first formulas as these are only steps to the result.

I see the field "concitional" on the formula tab in the properties of the pivot table.

But I only manage to enable or disable the formulas completely with the condition.

Can anybody give me a hint how to create a condition that lets the formula beeing calculated but keeps it hidden?

kind regards

Philip

2 Replies
Not applicable
Author

have you tried this ?...

i mean invisible option

Not applicable
Author

thanks for the suggestion.

unfortunately this option is not available in the properties of a pivot tableno_invisible_option.png