Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

CASE Statement

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: CASE Statement

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: CASE Statement

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


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Not applicable

Re: CASE Statement

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