topic Re: countries should be fetched from web in QlikView

countries should be fetched from web

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I am very new to QlikView. But i have got one task which i am not able to perform. I have one listbox which contains ip addresses. The second listbox contains the countries. If i select one ip address then the associated country to that ip address gets highlighted.

But my task is that the countries should be fetched from web and when i select a particular ip address then country associated with that ip address should be fetched from web. Is there any solution to this??

Re: countries should be fetched from web

RonaldDoes — Wed, 10 May 2017 07:10:51 GMT

Hi Ashish,

Where "on the web" do you query your IP-addresses?

QlikView supports direct discovery for real-time database lookups.

Re: countries should be fetched from web

Wed, 10 May 2017 07:13:21 GMT

Hi Ronald,

can u tell me how??

Re: countries should be fetched from web

arulsettu — Wed, 10 May 2017 07:29:52 GMT

may be you can create a inline table for the countries and ip-address

example:

load inline [

ip_address,country

192.3.4.5,india

192.5.6.7,us

192.8.9.1,uk

192.1.2.3,canada

];

ip_address from DB and inline table should be same

Re: countries should be fetched from web

Wed, 10 May 2017 07:42:00 GMT

But suppose there are thousnds of ip addresses.

Then how can we write so many addreses in inline table? will it be convenient?

Re: countries should be fetched from web

Anil_Babu_Samineni — Wed, 10 May 2017 07:44:24 GMT

I would better to install the Data Market for that? There you can fetch country data

Re: countries should be fetched from web

Anonymous — Wed, 10 May 2017 07:50:45 GMT

Hi!

What do you mean with "on the web"?

Do you want to load data from a table that is in a web page?

Giuseppe

Re: countries should be fetched from web

RonaldDoes — Wed, 10 May 2017 07:59:41 GMT

I don't understand the question.

What information do you want to fetch from the internet?

I'm pretty certain there is no Qlik Data Market item containing every IP-address on the planet with their corresponding country, so I wouldn't rush there.

Re: countries should be fetched from web

Anonymous — Wed, 10 May 2017 08:03:36 GMT

Sorry but I dont understand, where are located the information?

I mean the thousand ip adress and relative country.

Re: countries should be fetched from web

Anonymous — Wed, 10 May 2017 08:06:34 GMT

Can you post a sample of application?

Re: countries should be fetched from web

Wed, 10 May 2017 08:38:04 GMT

actually i have one file. In that i have mapped some ip addresses to countries manually. But what if ip addresses increases. So mapping it manually would be a very tedious task.

So i want a solution where i could map numerous ip address with associated countries.

Re: countries should be fetched from web

Wed, 10 May 2017 08:40:42 GMT

I want to map numerous ip addresses to the associated countries. I have one file where i have mapped it manually. But there were very few ip addresses so manual mapping was easy. But suppose there are numerous ip address. So is there any solution for that to map?

Re: countries should be fetched from web

Anonymous — Wed, 10 May 2017 09:09:22 GMT

I understand. I dont know where you can find this. Maybe you can use the IP range per country and generate the IP and use this in Qlikview?

It is only a idea.

For example from here:

Country IP Ranges Generator

IP Address Ranges by Country | IP2Location LITE

Re: countries should be fetched from web

Anonymous — Wed, 10 May 2017 09:18:54 GMT

Sorry but the answer that I write dont published...

I understand. I dont know where you can find this. Maybe you can use the IP range per country and generate the IP and use this in Qlikview?

It is only a idea.

You can use Google and try Country IP Ranges Generator or other website.

Re: countries should be fetched from web

Wed, 10 May 2017 09:32:32 GMT

ok thanks,

is there any API which can be used to geocode the ip address and provide us the location?

Re: countries should be fetched from web

Anonymous — Wed, 10 May 2017 09:39:14 GMT

I dont know, I think you can search on line, it seems that dont exist something in Qlik market.

Re: countries should be fetched from web

RSvebeck — Wed, 10 May 2017 09:59:45 GMT

Dynamically looping through thousands of IP adresses and getting back the country for each is possible to do.

You can do this in your Qlikview or Qlik Sense script with the REST connector using for instance this API

http://ipinfo.io/developers

Good Luck

Robert