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'))
Go to Solution.
Or just this
If(HIPAAStmt = -1, 'Yes', 'No')
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.