countries should be fetched from web

[#1]

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??

[RonaldDoes]

Hi Ashish,

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

QlikView supports direct discovery for real-time database lookups.

[#3]

Hi Ronald,

can u tell me how??

[arulsettu]

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

[#5]

But suppose there are thousnds of ip addresses.

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

[Anil_Babu_Samineni]

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

[Anonymous]

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

[RonaldDoes]

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.

[Anonymous]

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

I mean the thousand ip adress and relative country.

[Anonymous]

Can you post a sample of application?