Help with images anf 'if' condition!!

[Anonymous]

Hello guys, i'm kind of new at this, and my question is next:

i would like to appear or hidde an image depending result of a list , for example, i have 'FlagImages', 'Names' and 'TimesVisited',

FlagImages = images of countries

Names= names of persons

TimesVisited= the ammount of countries they have visited

This names represent people that could have visit different countries, and what i'm triying to do is that when select a name on this list i need to show with a flag image  all different nations this person  have visited, it could be 2 or 6, etc.

I know how to hide or appear a text object on wich i have set the image: if(country = 'mexico',1,0) at condition chart

but how can i tell that  depending of a result of a different table it will be the image and the amount of flags?.

I guess in sql could be like this:  SELECT IF(result of list name = 'name')TimesVisited FROM person.

I've tried next on each object : if(NameList = 'peter',1,0) at text object/design/condition. The result should be  3

different flags images appearing but no flag is deployed, 

P.s.

sorry for gramatics apreciate any help please!!

[jwjackso · Accepted solution]

Try the formula below in the conditional show for the flags.

If(Count({$<country={'mexico'}*P(country)>}NameList) > 0,1,0)

[Anonymous]

THANKS it worked!