topic Need some help here. in QlikView

Need some help here.

Thu, 10 Mar 2011 09:36:23 GMT

Hello all
Im totally new in QV.

I have problem with delivery company report.
I have table like this:


load * inline [
country, postal1, postal2, zone
AB, 1000-2000, 1000-3000, 1
AB, 1000-2000, 3001-5000, 2
AB, 1000-2000, other, 4
AB, 2001-4000, , 3
AB, 4001-5000, , 1
AC, , 1000-2500, 9
AC, , 2501-3000, 7
AC, , other, 2
AZ, , , 5
..................
];

I have postal code from other table like AB, 2540. I need when i select postal code it should show zone number defend on postal1 and postal2. But some countries have postal1 but dont have postal 2, some are don't have postal1 but have postal2, some are dont have bot of them and some are have bot of them.
please help me. Its making real headache for me now.

Need some help here.

Thu, 10 Mar 2011 12:37:44 GMT

hey someone any ideas to do this.

Need some help here.

Miguel_Angel_Baeyens — Thu, 10 Mar 2011 13:25:48 GMT

Hi,

Check the document attached. It's not clear when a postalcode belongs to one of each postal1 or postal2, if you need to keep comparing or what.

You will likely need to change the script to fit your needs, anyway, the Intervalmatch() seems to return some probable values. Data will need some cleanup as well, since Intervalmatch() only works with numeric values ("other" will return unexpected results).

Hope that helps.

Need some help here.

Thu, 10 Mar 2011 13:35:50 GMT

Hi Miguel

im really glad to hear something from you.
Now I'm trying to use intervalmatch in my data as you suggest.
After that i'll post.

Thank you.