Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

viveksingh
Contributor II

Qliksense-Set-analysis with SQL IN() funtion

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

2 Replies
MVP
MVP

Re: Qliksense-Set-analysis with SQL IN() funtion

Try this:

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

lakkydev
Contributor II

Re: Qliksense-Set-analysis with SQL IN() funtion

Try this

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