15 Replies Latest reply: Feb 22, 2018 5:22 PM by omar bensalem RSS

    Pivot Table Filter on Column

    Buyi Zhang

      I would like to do the following in Qlik Sense.  I am wondering if there is a way to do it using a pivot table.   Alternatively, I can produce a straight table, and do the same operation.   But I'd prefer to use pivot table to do it.  Thanks!

       

      I created a pivot table using like table 1

       

      Table 1

       

      RegionABC
      North100010001000
      East200050
      West2002000
      South1000

       

      Now I want to filter on product C so that only show rows where sales for C is greater than 0.  I want the product selection to be user defined.    i.e. If the user select product A, then we would filter on A using the same condition.  

       

      Table 2

       

      RegionABC
      North100010001000
      West2002000