Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Rick
Contributor
Contributor

Match using a variable that contains a list of values

Hi everyone, 

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:

'','12',1242','2312','1452','1276','5512','1452','1223','1982','6712','8712','7812','1212','4312',''

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 resultTable1, table2 and variable result

Labels (2)
1 Solution

Accepted Solutions
santhiqlik
Creator
Creator

Hi

Have you tried this ?

match([RSC.RSC_IDE],$(vRSC_IDE))

View solution in original post

2 Replies
santhiqlik
Creator
Creator

Hi

Have you tried this ?

match([RSC.RSC_IDE],$(vRSC_IDE))

View solution in original post

Rick
Contributor
Contributor
Author


@santhiqlik wrote:

Hi

Have you tried this ?

match([RSC.RSC_IDE],$(vRSC_IDE))


Thanks for the reply. That worked.