how to exclude item in other list - Set Analysis

[kamal_sanguri]

Hi Experts,

I am stuck in a situation where I need to exclude some items from a selection and those items are in a different list. I dont want to hard code those items in set analysis, as this list is periodically updated..

For Ex:

Table_1:

Item1  Rate

A          15

B           20

C          25

D          30

Table2:

Item2

B1

C

I want to do something like this

sum( {<{Item1} -= {Item2}> Rate}

Thanks,

Kamal

[Clever_Anjos]

sum( {<{Item1} -= P(Item2)> Rate}

[sunny_talwar]

Try this expression: PFA the qvw for reference

=Sum({<Item1 -= {$(=Concat(Chr(39) & Item2 & Chr(39), ','))}>}Rate)