Computed Field

[ena1309]

Hi guys,

I am having big trouble recreating this TABLEAU computed field in Qlik, 
please help

IF(LEFT([Quantity],1)<>"0") THEN (FLOAT(REPLACE(TRIM([Quantity]),".",""))) ELSE (FLOAT(TRIM([Quantity]))) END

Thank you in advance
Ena

[Andrei_Cusnir · Accepted solution]

Hello,

Perhaps you can try this expression:

if(
 NOT LEFT( [Quantity] , 1 ) = '0', 
 Num(Replace(TRIM( [Quantity]), '.', '')), 
 Num(TRIM([Quantity]))
)

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.