Hide Text based on condition??

[qlikuser222]

Hi,

i have a requirement where i need to hide the text based on conditions.

for example:

In the below, if there is no number before True i need to hide the text and show only Goal or Strike etc respectively

Goal - True - Yes - No  ----> Should show Goal

Strike - True - Yes - No .....> Should show Strike

Start - 5 true - Yes - Yes....> Should show  Start - 5 true - Yes - Yes

Can any one please help me with this requirement??

Thanks

[sunny_talwar · Accepted solution]

May be this:

If(IsNum(Right(SubField(Upper(FieldName), ' True', 1), 1)), FieldName, SubField(FieldName, ' - ', 1) as NewFieldName