Hello Can someone help me replicate the same formula in Qlik Sense :-
1)
if NumericText(left({@Item_TranCodeExpense},8)) then left(left({@Item_TranCodeExpense},4)+ReplicateString("0",4),4) else if NumericText(left({Command.SFIELD_9},8)) then if mid({@Item_TranCodeExpense},1,8)="????????" then left(left({Command.SFIELD_9},4)+ReplicateString("0",4),4) else if not NumericText(left({Command.SFIELD_9},8)) then left(left({Command.LOCAL_ACC_NO},4)+ReplicateString("0",4),0)
2)
stringvar tmpTCExpense:=''; if not isnull({Command.GL_EXPENSE_ACCOUNT}) then tmpTCExpense:={Command.GL_EXPENSE_ACCOUNT} else tmpTCExpense:='39990000999999999+TC00'; if tmpTCExpense='' then tmpTCExpense:='39990000999999999+TC00';