topic class function, limit of intervals in QlikView

class function, limit of intervals

arsenal1983 — Fri, 15 Jan 2016 08:23:34 GMT

Hi,

I've made a class function with limit of intervals:

=if(IMEI_SALE.DEALER_PURCHASE_PRICE_NET > 3000 , '3000 +', Class(IMEI_SALE.DEALER_PURCHASE_PRICE_NET,800, 'PRICE'))

The problem is that the last interval from class function is from 2400 to 3200 while in reality is from 2400 to 3000. Is there any way to correct the value 3200 to 3000?

Re: class function, limit of intervals

marcus_sommer — Fri, 15 Jan 2016 12:09:17 GMT

Try:

= if(IMEI_SALE.DEALER_PURCHASE_PRICE_NET > 3000 , '3000 +', Class(IMEI_SALE.DEALER_PURCHASE_PRICE_NET,

if(IMEI_SALE.DEALER_PURCHASE_PRICE_NET>= 2400, 600, 800), 'PRICE'))

But better would be to use '3200 +' or to change the interval-size to 750 - it's more logically.

- Marcus