Rewrite QlikView Expression to Qlik Sense Expression

[ShellyG]

Hi there, 

Can someone please help me rewrite the following expression into a way that will work in Qlik Sense's script:

CASE WHEN Group = 'FirstGroup.' or Group = 'First'
THEN
(CASE WHEN SUBSTRING([Group Number],7,1) Like '%T' OR SUBSTRING([Group Number],7,3) Like '%T#A%'
THEN NULL
ELSE [Group Number]
END)
ELSE [Group Number]
END as 'GroupCode'

Thanks in advance!

[JuanGerardo · Accepted solution]

If(Group = 'FirstGroup.' or Group = 'First',

   If(Mid([Group Number],7,1) = 'T' OR Mid([Group Number],7,3) = 'T#A',

      Null(),

      [Group Number]

      ),

   [Group Number]

   ) as 'GroupCode'

JG