CASE Statement

[Anonymous]

Hello, I'm wanting to add the below Case statement into qlikview script. Any idea on how to do this?

CASE when COUNT(X.id ) > 1 THEN 'X'
ELSE '' END AS Dual

[Gysbert_Wassenaar · Accepted solution]

If(COUNT(X.id ) > 1, 'X', '' ) as Dual

[#3]

Use IF statement in Qlikview and its equality in SQL Case function.