9 Replies Latest reply: Oct 18, 2013 2:14 AM by kumar sinha RSS

    Preserve pivot table after selection

      My colleagues and I have been trying to solve this for a while now...

       

      A customer requirement is to produce a table in Qlikview which does not collapse when you click on one of the cells. Basically, we don't want the pivot to change when you filter on one of the dimensions within the table object.

       

      We've tried the method of ticking 'Show all values', and unticking 'Suppress zero values' but this just preserves the format rather than the actual numbers themselves.

       

      Detaching is not an option as we still need to filter the table by other dimensions outside of it.

       

      Can anyone help with this or provide guidance?

       

      Thanks

      Adam