topic Match in QlikView

Match

Thu, 17 Jun 2010 13:50:52 GMT

I have a Table of CITY , I dont want to write city names in Match function again and again I just need a Field which should fetch city names and go for matching in Match function. For example it takes long if I have to write 25 city names, is there any simple solution that city be fetched in Match function without writing them in Match function?.

CITY:

London

New York

Maxico

and so on all the cities upto 100.

if (Match (City, 'London', 'New York', 'Maxico','Karachi','Mumbai')) as XYZ, this condition is working but I have 100 cities then what should i do, I type or fetch automatically from city table.

Regards,

Khalid

Match

Thu, 17 Jun 2010 19:31:49 GMT

I hope you are looking for the solution in QVW

Match

johnw — Thu, 17 Jun 2010 22:27:45 GMT

This is the third thread I've found where you asked the same question. Try to post your question once, in one thread, and wait for a response, rather than posting the same question everywhere. See my seven different answers in the thread below. All seven of mine were different than Devang's, so now you have at least eight different ways to solve the same problem.

http://community.qlik.com/forums/p/27167/117203.aspx#117203

Match

Mon, 27 Jun 2011 23:52:14 GMT

Hi John,

I am not able to open the thread you have specified above. Could you please provide me link to the thread with your solutions. I am trying to find solution to a similar problem and running into issues.

Re: Match

Mon, 27 Jun 2011 23:53:09 GMT

Hi John,

Match

johnw — Tue, 28 Jun 2011 00:25:49 GMT

It looks like this is link now.

http://community.qlik.com/message/61247#61247