topic Re: Simply syntax question in QlikView

Simply syntax question

Thu, 15 Nov 2012 15:35:15 GMT

I want to do the equivalent, in a calculated dimension, of a SQL IN statement.

Specifically, I only want to show rows where the UserID is the SalesRep or one of the sales assistants, so I want the condition to read:

if(UserID=SalesRep OR UserID IN ('John','Mary','Ted'),UserID,Null())

But QV doesn't have an "IN" function that I could find, and I don't want to type out four different OR conditions. Surely this exists! I've been through the documentation, and with its terrible search function, can't find anything that tells me how to do this.

Can someone please help?

Thanks

Re: Simply syntax question

Gysbert_Wassenaar — Thu, 15 Nov 2012 15:36:42 GMT

try using match: if(UserID=SalesRep OR match(UserID,'John','Mary','Ted'),UserID,Null())

Re: Simply syntax question

MayilVahanan — Thu, 15 Nov 2012 15:38:01 GMT

Try with match() function

Like this

if(Match(UserID, 'John','Mary','Ted'),UserID,Null())

Hope it helps

Re: Simply syntax question

Thu, 15 Nov 2012 15:43:22 GMT

Thanks, that worked fine.

Re: Simply syntax question

Thu, 15 Nov 2012 19:00:29 GMT

Thanks Mayil, Gysbert beat you to it!

Re: Simply syntax question

CELAMBARASAN — Thu, 15 Nov 2012 19:11:42 GMT

Match itself does OR operation . so simply it also works

if(match(UserID,SalesRep,'John','Mary','Ted'),UserID,Null())

Hope it helps

Celambarasan