1 Reply Latest reply: Jul 17, 2017 5:45 AM by Konstantinos Mertzianis RSS

    Limit Pivot Table Data in QlikSense

    Allan Thomas



      I have a Pivot Table with 3 Line dimension, 1 column dimension and 2 measures.

      The line dimensions are :

      1. Customer Family
      2. Customer Name
      3. Product Name


      The measures are :

      1. Sum(Sales)
      2. Sum(Margin)


      I put a relative value limitation of >= 20% on the dimension "Customer Name"  and check the "Show others"


      Capture 1.PNG


      How to group all the product below Customer "Others", without grouping the products the other customers for example "Galec"

      Thanks for your help