2 Replies Latest reply: Jul 31, 2012 7:34 AM by Philip Munz RSS

    Conditional hiding formulas in pivot tables

    Philip Munz

      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