Discussion board where members can get started with Qlik Sense.
I need your help. I have a table(visualization)(table1) that I need to filter by the results of another table(visualization)(table2).
Table1 has to show only ID's that are not present on table2.
I created, based on table2 data, a variable that contains the list of records to be avoided.
vRSC_IDE = Text(Chr(39)&concat(Distinct(If([TSH_DTE.autoCalendar.Date]>= Date('28/02/2019')and (RST < 2 or RST >= 8),[TSH_HIST.RSC_IDE])&Chr(39)&Chr(44))&Chr(39))&Chr(39)).
The result of the variable is something like this:
and on table1, I am trying to use match see the results, and later, filter it using
=If(match([RSC.RSC_IDE],vRSC_IDE) = 0,[RSC.RSC_IDE])
The problem lies on the result showing on the = match([RSC.RSC_IDE],vRSC_IDE) portion... it is all showing 0s as you can see bellow
Can you please help me solve this issue?
Thanks in advance.
Table1, table2 and variable result
Have you tried this ?
View solution in original post
@santhiqlik wrote:HiHave you tried this ?match([RSC.RSC_IDE],$(vRSC_IDE))
Thanks for the reply. That worked.