topic Re: Rewrite QlikView Expression to Qlik Sense Expression in App Development

Rewrite QlikView Expression to Qlik Sense Expression

ShellyG — Wed, 28 Apr 2021 14:47:33 GMT

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!

Re: Rewrite QlikView Expression to Qlik Sense Expression

JuanGerardo — Wed, 28 Apr 2021 15:00:05 GMT

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

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

Null(),

[Group Number]

) as 'GroupCode'