9 Replies Latest reply: Jan 6, 2014 7:33 AM by Asha Morjaria RSS

    Fixed/locked dimensions in a pivot

    Robert Svebeck

      Hi

       

      I have a pivot table with three dimensions.

       

      As expected, when I make selections in my document, the dimensions are reflecting the possible values based on what data I actually have, like always in Qlikview. The more selections i make, the smaller my pivot gets (showing fewer and fewer values in my dimension columns).

       

      My issue is that I now need to make the pivot appearance fixed.

      I want the pivot to show all values in my dimensions regardless of what selections I make in the dokument.

      I do not want to make it  detached, since the numbers in my pivot must change depending on what I select, but the numbers should be zero or null if there are no valid numbers.

       

      I have tried "Show all values" but it still does not make my pivot dimensions fixed.

       

      Is it possible to do this?

       

      brg

       

      Robert