IntervalMatch - Ranges not mapped

Mon, 20 May 2013 21:11:20 GMT

I am analyzing certain group of students deposits. I want to count the number of users who has deposits with in the range.

TRANSACTION:

LOAD USER_ID,

AC_BALANCE,

MONTH

FROM

(ooxml, embedded labels);

BAND:

load * inline

[

RangeL, RangeH, Band

0,0.999, 0-1

1,9.999, 1-10

10,49.999, 10-50

50,99.999, 50-100

100,199.999, 100-200

200,299.999, 200-300

300,499.999, 300-500

500,999.999, 500-1000

1000,1999.999, 1000-2000

2000,2999.999, 2000-3000

3000,4999.999, 3000-5000

5000,9999.999, 5000-10000

10000,19999.999,10000-20000

20000,100000, 20000-100000

];

DEP_BALANCE:

IntervalMatch(AC_BALANCE) load

RangeL, RangeH

resident BAND;

I have manually checked the data I do not have any user who has more than 25000 balance.

DIMENSION; Band

EXPRESSION: =Count(DISTINCT USER_ID)

Final chart I am getting as follows. The last range contains 75 users and I checked few of these users and they have a balance of 45.625 It should be mapped under 10-50 range. I am unable to figureout what mistake I am making.

Can I request your help?

Thank you

Re: IntervalMatch - Ranges not mapped

Tue, 21 May 2013 01:08:13 GMT

can u post ur Dec2012 file ?

topic Re: IntervalMatch - Ranges not mapped in QlikView

IntervalMatch - Ranges not mapped

Re: IntervalMatch - Ranges not mapped