Match

[#1]

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

[#2]

I hope you are looking for the solution in QVW

[johnw]

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

[#4]

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.

[#5]

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.

[johnw]

It looks like this is link now.

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