How to convert to Qlik Sense Expression from Tableau Calculation Field ?

[gowrishankarangrybird]

How to convert  to Tableau Calculation Field  to Qlik Sense Expression from?

Below Expression not working in Qlik Sense . How to  Write ?

IF CONTAINS([AppsLate], " ICA") THEN
MID([AppsLate],FIND([AppsLate], " ICA"))
ELSEIF CONTAINS([AppsLate], ".ICA") THEN
MID([AppsLate],FIND([AppsLate], ".ICA"))
ELSEIF CONTAINS([AppsLate], CHAR(10)+"ICA") THEN
MID([AppsLate],FIND([AppsLate], CHAR(10)+"ICA")) END

Thanks in Advance

[MendyS]

Hi @gowrishankarangrybird 

if I got you correct, did you try to convert from Tableau to Qlik formula?

is it is,  so try this - 

IF (Match ([AppsLate], " ICA"),

mid( [AppsLate], index( [AppsLate], "ICA")),

IF(Match ([AppsLate], ".ICA"),
mid( [AppsLate], index( [AppsLate], ".ICA")),

if(Match ([AppsLate]," ICA"),
mid( [AppsLate], index( [AppsLate], " ICA"))))

I try to convert for you the functions, but I am not sure - what you try to do - let me know the purpose and I give the exact formula, 
Thanks

[Mark_Little]

Hi @gowrishankarangrybird 

For a start the If statement is syntax should be

If('Argument' , True,  False) Then and else are just comma's, If can be nested.

Contain would need to be wildmatch()

[gowrishankarangrybird · Accepted solution]

Worked with below expression 

=iF (SubStringCount (AppsLate, 'ICA'),
mid( [AppsLateR], index( [AppsLate], 'ICA')),

IF(SubStringCount ([AppsLate], '.ICA'),
mid( [AppsLate], index( [AppsLate], '.ICA')),

if(SubStringCount ([AppsLate],'ICA'),
mid( [AppsLate], index( [AppsLate], 'ICA')))))