topic intervalmatch help? in QlikView

intervalmatch help?

Wed, 16 Mar 2011 13:56:57 GMT

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

intervalmatch help?

Thu, 17 Mar 2011 07:40:41 GMT

any help?

intervalmatch help?

Mon, 21 Mar 2011 09:02:29 GMT

Anything?

intervalmatch help?

suniljain — Mon, 21 Mar 2011 09:25:46 GMT

0000-9999 should be 9000-9999.

and this resolve your problem.

intervalmatch help?

Mon, 21 Mar 2011 10:40:32 GMT

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.

intervalmatch help?

Mon, 21 Mar 2011 13:03:09 GMT

[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
....|________|...............|_____________________|....................|_____|.........

intervalmatch help?

suniljain — Tue, 22 Mar 2011 05:15:26 GMT

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