topic Re: SQL IN function in QlikView in QlikView

SQL IN function in QlikView

Anonymous — Thu, 20 Oct 2011 11:55:57 GMT

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

Thu, 20 Oct 2011 12:11:17 GMT

Hi henco,

Try this :

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

Regards,

Eric.

Anonymous — Thu, 20 Oct 2011 12:15:41 GMT

Thanks a lot Eric.

Regards,

Henco

Sokkorn — Thu, 20 Oct 2011 12:16:33 GMT

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