Hide Text based on condition??

qlikuser222 — Wed, 04 May 2016 18:24:23 GMT

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

Re: Hide Text based on condition??

sunny_talwar — Wed, 04 May 2016 19:35:18 GMT

May be this:

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