Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

intervalmatch help?

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

6 Replies
Not applicable
Author

any help?

Not applicable
Author

Anything?

suniljain
Master
Master

0000-9999 should be 9000-9999.

and this resolve your problem.

Not applicable
Author

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.

Not applicable
Author

[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
Master
Master

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