Help with images anf 'if' condition!!

Anonymous — Wed, 28 Feb 2018 19:31:18 GMT

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

Re: Help with images anf 'if' condition!!

jwjackso — Wed, 28 Feb 2018 22:47:38 GMT

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

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

Re: Help with images anf 'if' condition!!

Anonymous — Wed, 28 Feb 2018 23:01:54 GMT

THANKS it worked!

topic Re: Help with images anf 'if' condition!! in QlikView

Help with images anf 'if' condition!!

Re: Help with images anf 'if' condition!!

Re: Help with images anf 'if' condition!!