topic See if field code match in other table in QlikView

See if field code match in other table

cristian_av — Wed, 25 Nov 2020 16:16:04 GMT

I have two tables that are not related.

I need to see in a Simple Table, for each row, how many codes are possible in match in the other table.

Tables are not related in the data model. (And it's really hard to make them related, as I din't make the model)

So far, I've tried with the following expressions. None of this worked:

=Count({<CurvaVariedad={"$(=VariedadRealCodigo)"} >}CurvaVariedad)

=Count({<CurvaVariedad={"$(=Max(Aggr(Max(VariedadRealCodigo),VariedadRealCodigo,[Variedad Real])))"} >}CurvaVariedad)

Table 1:

Table 2:

Thanks!

Re: See if field code match in other table

neelamsaroha157 — Wed, 21 Nov 2018 18:16:52 GMT

Try this -

Count({<CurvaVariedad={$(=chr(39) & If(GetPossibleCount(VariedadRealCodigo)>0, Concat(DISTINCT VariedadRealCodigo,chr(39)&','&chr(39))) & chr(39))} >}CurvaVariedad)

Re: See if field code match in other table

cristian_av — Wed, 21 Nov 2018 20:53:14 GMT

Set analysis don't work for dimension values. But instead, I used an If that is slower, but works.
Sum(if(VariedadRealCodigo=CurvaVariedad,1,0) )>0,1,0