topic interval match in QlikView

interval match

Thu, 25 Apr 2013 13:38:34 GMT

I am tried to use interval match to combine 2 tables.

It did not worked when I tried to combine alphanumeric fields such as cost centers.It worked for numeric fields such as account numbers.

Is there any other way to combine alphanumeric fields with interval match?

Re: interval match

swuehl — Thu, 25 Apr 2013 13:45:14 GMT

Intervalmatch only works for numeric fields.

How do you want you alphanumeric fields matched? What kind of interval should your alphanumeric values - that define this interval - span (i.e. if your limits are A and B, what values should be generated for your interval?)?

Re: interval match

Thu, 25 Apr 2013 20:54:50 GMT

I have one table with account ,cost center ,value and date , another table account range, cost center range, row, market .

I need to have value total by row and market. You can see data below tables.

If needed there are two more tables one for all valid accounts , second for all valid cost centers.

Cost centers are like C100, C120,D100,D200...

row

account	cost center	amount	period	year
111	C100	100	1	2013
112	C110	200	1	2013
114	C200	300	1	2013
115	D200	200	2	2013
200	F210	200	2	2013

marketacc1
acc2
cc1
cc2

1406
2888
100
199
C100
C199

1406
5888
100
199
C200
ZZZZ

1500
2888
200
299

ZZZZ

Re: interval match

Thu, 25 Apr 2013 20:58:23 GMT

Pls find the samples within the attached files