Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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'))

1 Solution

Accepted Solutions
sunny_talwar

Or just this

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

View solution in original post

4 Replies
sunny_talwar

May be this:

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

sunny_talwar

Or just this

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

Not applicable
Author

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

I make this harder than it really is.

Thank you

LhZagora
Contributor
Contributor

HEllo,

 

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

Can you help me please ?