SQL IN function in QlikView

[Anonymous]

Hi all,

I am looking for the IN function (which I know from SQL) in QlikView.

As long as I don't know this function my expression is for example:

=if(accountnumber='1' or accountnumber='2', accountnumber, 0)

In SQL I would do it this way:

where accountnumber in('1', '2')

Can anyone help me with this? Thanks in advance.

Regards,

Henco

[#2 · Accepted solution]

Hi henco,

Try this :

where MATCH(accountnumber,'1','2')

Regards,

Eric.

[Anonymous]

Thanks a lot Eric.

Regards,

Henco

[Sokkorn]

Hi Henco,

Try it with this set analaysis: sum({$<accountnumber={'1','2'}>} accountnumber)

Do let me know, if you have a good luck with this.

Regards,

Sokkorn