Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

athomas2230
New Contributor

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

Tags (1)
1 Reply
kmn
New Contributor II

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

-K.