Discussion Board for collaboration related to QlikView App Development.
I have 5 fields
orderno catergory bad1 bad2 bad3 required field(needs tobe calculated)
1 a yes bad
1 b yes bad
1 c bad
2 d good
2 e good
if any of the 3 bad's is yes , that order no should be bad or else good.
anyone help me in writing the logic for required field.
Thanks in advance
May be just this
If(RangeMax(bad1, bad2, bad3) = 'yes', 'bad', 'good')
If(SubStringCount(bad1&'|'&bad2&'|'&bad3, 'yes') > 1, 'bad', 'good')
View solution in original post