Qliksense-Set-analysis with SQL IN() funtion

[viveksingh]

Hi Experts,

I want to use Sql IN() function along with set-analysis.

[Temp]:

load *

Inline [

NAME,SAL

abc,10

def,20

ghi,30

];

sum({<match(NAME,'abc','def','ghi')>}SAL)

The above expression is not correct. can you please correct the above one?

Thanks,

Vivek

[sunny_talwar]

Try this:

Sum({<NAME = {'abc','def','ghi'}>}SAL)

[Anonymous]

Try this

Pick( Match(NAME,'abc','def','ghi'),Sum(SAL),sum(SAL),Sum(SAL))