Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Re: display 0 as NO or -1 as Yes

Or just this

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

View solution in original post

4 Replies
Highlighted

Re: display 0 as NO or -1 as Yes

May be this:

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

Highlighted

Re: display 0 as NO or -1 as Yes

Or just this

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

View solution in original post

Highlighted
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

Highlighted
Contributor
Contributor

Re: display 0 as NO or -1 as Yes

HEllo,

 

What if i have more than two values, i have value from 0 to 4

Can you help me please ?