Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

display 0 as NO or -1 as Yes

I have tried a few different ways, in load statement and expression

=IF(Match(HIPAAStmt ='0' '-1','Yes' 'No'))

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: display 0 as NO or -1 as Yes

Or just this

If(HIPAAStmt = -1, 'Yes', 'No')

3 Replies
MVP
MVP

Re: display 0 as NO or -1 as Yes

May be this:

=Pick(RangeSum(HIPAAStmt, 2), 'Yes', 'No')

Highlighted
MVP
MVP

Re: display 0 as NO or -1 as Yes

Or just this

If(HIPAAStmt = -1, 'Yes', 'No')

Not applicable

Re: display 0 as NO or -1 as Yes

This works because it automatically knows the second value should be no.

I make this harder than it really is.

Thank you