Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor

Limit Pivot Table Data in QlikSense


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

Tags (1)
1 Reply

Re: Limit Pivot Table Data in QlikSense

Hi Allan,

Not quite sure if I understood what you want to achieve but take a look at the attached .qvf. 262456.PNG