topic Handling NULL values in INTERVAL MATCH: in QlikView

Handling NULL values in INTERVAL MATCH:

Thu, 17 Jun 2010 18:22:14 GMT

Hi,

I have a question on using interval match handling null values. Below is my table structure

RANGE_SELECTION:
LOAD * INLINE [
MIN_TEMP, MAX_TEMP, SLR_PCT_AGGR_RANGE_TEMP
-1000000, 0.099999999, '< 1%'
0.1, 0.24999999, '1% - 25%'
0.1, 0.32999999, '1% - 33%'
0.1, 0.49999999, '1% - 50%'
0.1, 0.65999999, '1% - 66%'
0.1, 0.74999999, '1% - 75%'
0.1, 0.79999999, '1% - 80%'
0.1, 0.89999999, '1% - 90%'
0.9, 10000.89999999, '90% +'
];

RANGE:
Inner Join (RANGE_SELECTION)
INTERVALMATCH (PCT) Load MIN_TEMP, MAX_TEMP RESIDENT RANGE_SELECTION;

I also want to include NULL values in the above table like whenever PCT is NULL, it should display 'NA'. I tried below load, but it was wrong
i.e.,
LOAD * INLINE [
MIN_TEMP, MAX_TEMP, SLR_PCT_AGGR_RANGE_TEMP
-1000000, 0.099999999, '< 1%'
0.1, 0.24999999, '1% - 25%'
0.1, 0.32999999, '1% - 33%'
0.1, 0.49999999, '1% - 50%'
0.1, 0.65999999, '1% - 66%'
0.1, 0.74999999, '1% - 75%'
0.1, 0.79999999, '1% - 80%'
0.1, 0.89999999, '1% - 90%'
0.9, 10000.89999999, '90% +'
, , 'NA'
];

I tried the above syntax, but it is not working for null values. I am not sure, how to define min and max for null. Can anybody help me out.

Handling NULL values in INTERVAL MATCH:

Thu, 17 Jun 2010 19:03:29 GMT

Null value for inlineLoad leave blank with , seperated

LOAD * INLINE [
MIN_TEMP, MAX_TEMP, SLR_PCT_AGGR_RANGE_TEMP
-1000000, 0.099999999, '< 1%'
0.1, 0.24999999, '1% - 25%'
0.1, 0.32999999, '1% - 33%'
0.1, 0.49999999, '1% - 50%'
0.1, 0.65999999, '1% - 66%'
0.1, 0.74999999, '1% - 75%'
0.1, 0.79999999, '1% - 80%'
0.1, 0.89999999, '1% - 90%'
0.9, 10000.89999999, '90% +'
, , 'NA'
];

Handling NULL values in INTERVAL MATCH:

Thu, 17 Jun 2010 19:16:55 GMT

Hi devang

Thanks for the reply. I tried it and it is also not working

Handling NULL values in INTERVAL MATCH:

Thu, 17 Jun 2010 19:38:56 GMT

Not sure what you are looking for, but in help

please look for IntervalMatch (Extended Syntax).

Handling NULL values in INTERVAL MATCH:

Thu, 17 Jun 2010 22:50:27 GMT

I tried using 'NULLASVALUE' before intervalmatch and he it doesn't help either. Basically, I want null values of PCT to be shown in the range 'NA', but this doesn't show NULL values

Handling NULL values in INTERVAL MATCH:

Thu, 17 Jun 2010 22:50:39 GMT

I tried using 'NULLASVALUE' before intervalmatch and it doesn't help either. Basically, I want null values of PCT to be shown in the range 'NA', but this doesn't show NULL values