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: 
Not applicable

interval in dimension

Hello

I have this problem:

- a list of personalized products with different width  (i.e. 3 products that are 751 mm width, 83 products that are 749 mm width, 7 products that are 832 mm width and so on) .... this dimension is called BASE_1;

- in the second column I have the quantity ... QTY.

I would like to totalize the column ' QTY' (sum) grouping the width in this way:

from     to

0          750

751      850

851      950

951     1050

>=1051

i tried the functions pick and class, but I'm in a lot of trouble.

Any help

thanks

g

2 Replies
aarkay29
Specialist
Specialist

I guess you are trying to match the Base_1 that fall between from and to base. If so, you need to use Interval Match

IntervalMatch

MarcoWedel

maybe helpful:

Custom Filter(unusual range)

regards

Marco