Select code in some values

[#1]

Hello.

I want to select the code in some values like in sql ( where code in ('01','11','12').

I use the fonction Qlikview match (  where match(trim(code),01','11','12') ). But the result give informations where trim(code) is different of '01','11','12'.

Match is it the correct fonction?

Best Regard's

[anbu1984]

Try just Match without second condition

Where Match(Trim(QUAI),'Q21','Q21-22','Q22','Q22-23','Q24','Q24-25','Q25');

and not(isnull(Trim(QUAI)));

[manideep78]

remove and not(isnull(Trim(QUAI)));

[#4]

I agy with you. I had this (and not(isnull(Trim(QUAI)))) after, where i see that  in CODE_QUAI there were CODE_QUAI which is not in (,'Q21','Q21-22','Q22','Q22-23','Q24','Q24-25','Q25'). When i delete it the result is the same.

[anbu1984]

What is the join key to Table TRAFICCOTENEUR_IMP_ABJ?

[#6]

is it possible to send you all the sript without make it public.

The table ESCALE in join to the table QUAI by key ESCLEUNIK. So ESCALE.ESCLEUNIK join to QUAI.ESCLEUNIK

[anbu1984]

Just noticed you have Left join. Is CODE_QUAI join key? Then extra values whatever you see, comes from table TRAFICCOTENEUR_IMP_ABJ

[#8 · Accepted solution]

Ok i try an other join (inner join). I make you returne.

[#9]

Think you. The result is correct now. My misteake was in the join. I use inner join to make my  fact tables and by mystake i inserte left join with tha table Quai insted of inner join.

Thank you very much!