topic Re: contains in expression in QlikView

contains in expression

rafael5958 — Fri, 03 Jul 2020 20:25:30 GMT

I need an expression that retuns true if the selected value is in a column. Example:

TABLE_A: LOAD * INLINE [ ID1 AAA BBB CCC DDD ]; TABLE_B: LOAD * INLINE [ ID2 AAA HHH KKK RRR ];

In Table_B if I click in AAA it should return true in a textbox. Tried to use FieldIndex, match, wildmatch, but it doesnt work, only when I select AAA in both tables, but Table_A cant be selected, it must search in all table.

Thanks.

Re: contains in expression

Taoufiq_Zarra — Fri, 03 Jul 2020 22:09:42 GMT

I don't know if I understood correctly, but here's a proposition...

Text Object Script :

=if(match(GetFieldSelections(ID2),$(=concat(chr(39)&ID1&chr(39),',')))>0,'True','False')

output :

Re: contains in expression

Vegar — Fri, 03 Jul 2020 22:13:33 GMT

Maybe you can try something like this:

=if(Count({<ID1=P(ID2) >} ID1) > 0, 'True', 'False')