2 Replies Latest reply: Oct 23, 2013 2:38 AM by Rajkumar Govindaram RSS

    Pivot table Hide column based on dimension value

      We need to hide a column dynamically based on dimension value using pivot table in QlikView 11

       

      Example

       

      Measure 2

      Dimension 1

      Dimension 2

      Dimension 3

      Measure 1

      Measure 2
      A10-11-2013Y1015
      B11-11-2013Y570
      C12-11-2013N3015

       

      When on pivoting Dimension-3 over the measures horizontally, system should show the measure 1 column when dimension-3 value is Y and should hide the measure 1 column when dimension-3 value is N.

       

      Any suggestion is appreciated.