topic interval in dimension in QlikView

interval in dimension

Fri, 10 Mar 2017 14:03:15 GMT

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

Re: interval in dimension

aarkay29 — Fri, 10 Mar 2017 14:40:57 GMT

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

Re: interval in dimension

MarcoWedel — Wed, 15 Mar 2017 00:30:41 GMT

maybe helpful:

Custom Filter(unusual range)

regards

Marco