4 Replies Latest reply: Jan 6, 2015 2:28 PM by Enrique Colomer RSS

    Pivot Table>>How to conditionally show dimension?

      Hi Qlikview Experts!

       

      How do I hide a dimension for a given expression?  My pivot table has the below dimensions and expressions. For a given expression, I want to hide dimensions.  For example, for the dimension, "Ben Income ($)", I only want to show "Ben Revenues".

       

      Dimensions:

      1. ProductionCategory
      2. MonthYear

       

      Expressions:

      1. Net Production ($)
      2. Ben Income ($)

      HQlikview Pivot.png