topic Add calculate field in Connectivity & Data Prep

Add calculate field

Mon, 27 Mar 2017 13:48:09 GMT

I'm trying to add a calculate field to a new sheet I'm importing. its a simple If statement like this:

if(len([Inventory Organization])=1,'00'&[Inventory Organization])

Basically if the organization has only 1 character in it, I want to add two leading zeros. I've used this many times in excel with no problem. Qlik keeps giving me an error on the = sign saying 'Unrecognized sybol:='.

Any help would be much appreciated.

Re: Add calculate field

sunny_talwar — Mon, 27 Mar 2017 14:24:25 GMT

Where exactly are you using this? In the script or front end?

Re: Add calculate field

Mon, 27 Mar 2017 14:27:03 GMT

Front end. I was able to achieve it in the load script... but trying to keep to just the GUI.

Here's screenshot if that's helpful.

Re: Add calculate field

Mon, 27 Mar 2017 14:48:10 GMT

Looks like it might have been answered here:

Re: Qlik Sense - Data Load - Add Calculated Field