Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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