topic Re: Conditional hiding formulas in pivot tables in QlikView https://community.qlik.com/t5/QlikView/Conditional-hiding-formulas-in-pivot-tables/m-p/375834#M1168215 <HTML><HEAD></HEAD><BODY><P>thanks for the suggestion.</P><P>unfortunately this option is not available in the properties of a pivot table<IMG __jive_id="19168" class="jive-image-thumbnail jive-image" onclick="" alt="no_invisible_option.png" src="https://community.qlik.com/legacyfs/online/19168_no_invisible_option.png" width="450" /></P></BODY></HTML> Tue, 31 Jul 2012 11:34:38 GMT 2012-07-31T11:34:38Z Conditional hiding formulas in pivot tables https://community.qlik.com/t5/QlikView/Conditional-hiding-formulas-in-pivot-tables/m-p/375832#M1168213 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>according to <A _jive_internal="true" class="loading" href="https://community.qlik.com/community.qlik.com/ideas/2084">http://community.qlik.com/ideas/2084</A> in QV 11 it should be possible to hide formulas in pivot tables with these formulas beeing calculated.</P><P>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.</P><P></P><P>I see the field "concitional" on the formula tab in the properties of the pivot table.</P><P>But I only manage to enable or disable the formulas completely with the condition. </P><P>Can anybody give me a hint how to create a condition that lets the formula beeing calculated but keeps it hidden?</P><P></P><P>kind regards</P><P>Philip</P></BODY></HTML> Tue, 31 Jul 2012 11:13:47 GMT https://community.qlik.com/t5/QlikView/Conditional-hiding-formulas-in-pivot-tables/m-p/375832#M1168213 2012-07-31T11:13:47Z Re: Conditional hiding formulas in pivot tables https://community.qlik.com/t5/QlikView/Conditional-hiding-formulas-in-pivot-tables/m-p/375833#M1168214 <HTML><HEAD></HEAD><BODY><P>have you tried this ?...</P><P></P><P>i mean <STRONG>invisible </STRONG>option</P></BODY></HTML> Tue, 31 Jul 2012 11:29:13 GMT https://community.qlik.com/t5/QlikView/Conditional-hiding-formulas-in-pivot-tables/m-p/375833#M1168214 2012-07-31T11:29:13Z Re: Conditional hiding formulas in pivot tables https://community.qlik.com/t5/QlikView/Conditional-hiding-formulas-in-pivot-tables/m-p/375834#M1168215 <HTML><HEAD></HEAD><BODY><P>thanks for the suggestion.</P><P>unfortunately this option is not available in the properties of a pivot table<IMG __jive_id="19168" class="jive-image-thumbnail jive-image" onclick="" alt="no_invisible_option.png" src="https://community.qlik.com/legacyfs/online/19168_no_invisible_option.png" width="450" /></P></BODY></HTML> Tue, 31 Jul 2012 11:34:38 GMT https://community.qlik.com/t5/QlikView/Conditional-hiding-formulas-in-pivot-tables/m-p/375834#M1168215 2012-07-31T11:34:38Z