0 Replies Latest reply: Feb 1, 2018 4:05 PM by Gwen Bobbie RSS

    Conditionally Suppress Pivot Dimension

    Gwen Bobbie

      Hello,

       

      I am fairly new to Qlikview, so please excuse my ignorance.  I am creating a pivot that will need to have certain dimensions suppressed based on the header.  Following is a snippet of current pivot:

       

      For example, I want to hide the BH, MEDICAL and NEGBAL dimensions under the Admin Fees header.  How would I go about doing that?  I assume the Conditional check box under the Expression tab, but I have tried many expressions there with no luck.  It either suppresses for everything or nothing.  Thank you in advance for any help you can provide!

       

      Following are more screen shots of pivot setup: