topic Re: Load Script - If/Then in QlikView

Load Script - If/Then

Wed, 17 Jun 2015 14:09:05 GMT

I have 2 spreadsheets.

Spreadsheet 1 Delivery number could appear in Fields ShipmentNumber or ReferenceNumber.

I want the script to do this:

If there is no Shipment Number, I want it to put the reference number in that field.

If (ShipmentNumber is null, ShipmentNumber, ReferenceNumber) as DeliveryNumber.

I have tried a few different scripts, but can't seem to get it to work.

I even tried it this way:

If( [ShipmentNumber ] > '1', [ShipmentNumber], [ReferenceNumber]) as DeliveryNumber

Re: Load Script - If/Then

alexandros17 — Wed, 17 Jun 2015 14:11:48 GMT

In qlik the syntax is

If (isnull(ShipmentNumber), ShipmentNumber, ReferenceNumber) as DeliveryNumber.

Otherways if you are loading with a Select and it doesn't work it means that the field is not null (maybe is filled with blank) so add to your condition something like

If (ShipmentNumber is null or trim(ShipmentNumber)='', ShipmentNumber, ReferenceNumber) as DeliveryNumber.

Re: Load Script - If/Then

stigchel — Wed, 17 Jun 2015 14:15:49 GMT

If these are really numbers you can use

Alt(ShipmentNumber, ReferenceNumber) as DeliveryNumber