Computed Field

ena1309 — Mon, 23 May 2022 08:06:39 GMT

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

Re: Computed Field

Andrei_Cusnir — Mon, 23 May 2022 08:39:59 GMT

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.

topic Computed Field in App Development

Computed Field

Re: Computed Field