Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
any help?
Anything?
0000-9999 should be 9000-9999.
and this resolve your problem.
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.
[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
....|________|...............|_____________________|....................|_____|.........
In this case, IF...ElSE...IF is better than Intervalmatch.