Discussion board where members can get started with Qlik Sense.
I have tried a few different ways, in load statement and expression
=IF(Match(HIPAAStmt ='0' '-1','Yes' 'No'))
Or just this
If(HIPAAStmt = -1, 'Yes', 'No')
View solution in original post
May be this:
=Pick(RangeSum(HIPAAStmt, 2), 'Yes', 'No')
This works because it automatically knows the second value should be no.
I make this harder than it really is.
What if i have more than two values, i have value from 0 to 4
Can you help me please ?