Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
have you tried this ?...
i mean invisible option
thanks for the suggestion.
unfortunately this option is not available in the properties of a pivot table