Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')))))
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
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()
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')))))