topic sample data for Country, State, City, Address and Post code(ZIP Code in QlikView

sample data for Country, State, City, Address and Post code(ZIP Code

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one please provide the sample data for Country, State, City, Address and Post code(ZIP Code).

I have one requirement in qlikview i need to match Address and Postcode with country.If it matches then its correct else wrong.

for that I need to derive one more new column for correct/Wrong.

Is theier any way to dervice the column like this.

For example country US if address is London then it need to show wrong.

Thanks in advance.

devarasu07 — Wed, 11 Oct 2017 04:29:47 GMT

Hi,

Try to use Northwind sample data set, attached file has customer table and you can use that.

bhavvibudagam — Wed, 11 Oct 2017 04:45:01 GMT

Hi Devarasu,

Thanks for your reply. How to Import this mdb file into qlikview. I am not able to see the files once i have selected Table files.

Thanks,

devarasu07 — Wed, 11 Oct 2017 04:50:30 GMT

Hi,

There are lot's of material available in web. just google it.

fyi,

Step1: