Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this:
Sum(If(Match(XID, 1, 2, 3) and ID = 1, SALES))
Hello thx that worked already.
Or this:
Sum({<XID = {1, 2, 3}, ID = {1}>} SALES)
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?).