topic Re: How is the syntax for a WHERE ID IN (1,2,3,4) in QlikView in QlikView

How is the syntax for a WHERE ID IN (1,2,3,4) in QlikView

Wed, 07 Dec 2016 10:22:48 GMT

Hello I have a Problem Im new to Qlik and normaly Im using SQL.

So im trying to figure out how to write something like SUM(CASE WHEN ID=1 AND XID IN (1,2,3) THEN SALES ELSE NULL END AS SALES in Qlik?

Thank you for your time.

sunny_talwar — Wed, 07 Dec 2016 16:08:31 GMT

May be this:

Sum(If(Match(XID, 1, 2, 3) and ID = 1, SALES))

Wed, 07 Dec 2016 16:16:33 GMT

Hello thx that worked already.

sunny_talwar — Wed, 07 Dec 2016 17:02:22 GMT

Or this:

Sum({<XID = {1, 2, 3}, ID = {1}>} SALES)

swuehl — Wed, 07 Dec 2016 17:04:04 GMT

But remember, latter will only work in the front end (chart expressions), not in the script (if that's where you want to use it?).