topic Re: Weight ranges in QlikView

Weight ranges

Mon, 15 Sep 2014 10:12:54 GMT

Hi,

I am trying to group some shipment data by weight range in a Straight table, however I can only get it to work partially.

At the moment I am using an IF function like this:

=If(SHP_WEIGHT <=0.50, '0.5KG',

If(SHP_WEIGHT >>0.50<=1.00, '1KG',

If(SHP_WEIGHT >>1.01<=2.00, '2KG',

If(SHP_WEIGHT >>2.01<=3.00, '3KG',

If(SHP_WEIGHT >>3.01<=4.00, '4KG',

'unknown')))))

This is not giving me the result I need.

The 2KG range now shows from 2.00 up to 6.00 and the 3KG range shows for 6.00 up to 16.00.

How can I fix this?

Re: Weight ranges

MK_QSL — Mon, 15 Sep 2014 10:15:26 GMT

=If(SHP_WEIGHT <=0.50, '0.5KG',

If(SHP_WEIGHT >0.50<=1.00, '1KG',

If(SHP_WEIGHT >1.00<=2.00, '2KG',

If(SHP_WEIGHT >2.00<=3.00, '3KG',

If(SHP_WEIGHT >3.00<=4.00, '4KG',

'unknown')))))

Re: Weight ranges

tresB — Mon, 15 Sep 2014 10:16:26 GMT

Class() would be a better option.

Re: Weight ranges

Mon, 15 Sep 2014 10:33:06 GMT

Hi Manisch,

I'm afraid your suggeestion is not working for me, I am not allowed to use the single ">" option, does this mean there is something wrong with the data?

Re: Weight ranges

MK_QSL — Mon, 15 Sep 2014 10:34:49 GMT

Definitely, we are missing Aggr here...

Something like

Aggr(

If(SHP_WEIGHT <=0.50, '0.5KG',

If(SHP_WEIGHT >0.50<=1.00, '1KG',

If(SHP_WEIGHT >1.00<=2.00, '2KG',

If(SHP_WEIGHT >2.00<=3.00, '3KG',

If(SHP_WEIGHT >3.00<=4.00, '4KG',

'unknown'))))),Shipment)

Expression

COUNT(Distinct Shipment)

Re: Weight ranges

deepakqlikview_123 — Mon, 15 Sep 2014 10:36:26 GMT

use class function for this,but in this case u will get fixed range,

Thanks