Conditionally Suppress Pivot Dimension

Anonymous — Thu, 01 Feb 2018 21:05:38 GMT

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:

topic Conditionally Suppress Pivot Dimension in QlikView

Conditionally Suppress Pivot Dimension