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';
tmpTCExpense;
