rafael5958
Creator
2020-07-03
04:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
contains in expression
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.
- Tags:
- qlikview_scripting
753 Views
1 Solution
Accepted Solutions
Taoufiq_Zarra
MVP
2020-07-03
06:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 :
Regards,
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
724 Views
2 Replies
Taoufiq_Zarra
MVP
2020-07-03
06:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 :
Regards,
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
725 Views
Vegar
MVP
2020-07-03
06:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe you can try something like this:
=if(Count({<ID1=P(ID2) >} ID1) > 0, 'True', 'False')
Vegar
Qlik Community MVP
Qlik Community MVP
723 Views