3 Replies Latest reply: Nov 6, 2017 5:40 PM by Glenn David RSS

    Exclude Mulitple Dimensions from a Pivot Table - Qlik Sense Desktop

    Phillip Mason

      Hello

       

      I'm trying to work out if there is a way I can exclude multiple dimensions from a pivot table (so they don't show as a row)

       

      Example Pivot

       

      Installer
      Measures
      A10
      B20
      C40
      D56
      E15
      F12
      G13

       

      I want to do something along the lines of

       

      =Installer <> ('C','D','G') so that I am only showing the data for the remaining Installers.

       

      There will be other Tables using these removed Installers, so I can't just filter them out.

       

      Do you know if this is possible, if so how?

       

      thank you