Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Limit Pivot Table Data in QlikSense

Hello,

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

1 Reply
kmn
Employee
Employee

Hi Allan,

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

-K.