intervalmatch help?

[#1]

Im new in QV.

My table is like this:

load * inline [
Country, postal_start, Postal_end, zones
EN, 1000, 2599, 1
EN, 5000, 7899, 3
EN, 0000, 9999, 2
MN, 0000, 9999, 5
GR, 6000, 8999, 3
GR, 0000, 9999, 2
.....
];

0000-9999 was null. i fill it 0000 to 9999 because i need to use intervalmatch to match some postal codes. And now problem is when i select some postal code like 1500 in EN its showing 2 rows inside of 0000-9999 and 1000-2599. I just need 1000-2599 this. How should i figure this out Please help.

Regards PS:sorry for my bad English

[#2]

any help?

[#3]

Anything?

[suniljain]

0000-9999 should be 9000-9999.

and this resolve your problem.

[#5]

i don't think so. I try to explain it little bit.

this is simpla draw of postal code now im using.

1000-2500 3500-7000 8000-9000
....|________|...............|_____________________|....................|_____|.........

0000-9999
|_________________________________________________________|

as you can see there is empty fields with dots. I need this empty fields values and after the intervalmatch() call it others.

[#6]

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.04.88.64/PL_5F00_test.qvw]

see attached file.

can someone find empty postal codes and give others values?

1000-2500 3500-7000 8000-9000
....|________|...............|_____________________|....................|_____|.........

[suniljain]

In this case, IF...ElSE...IF is better than Intervalmatch.