Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shakeeb_mohamme
New Contributor II

If Statements in Script

Hi,

Can someone help me with my script please.

Example data -

SupplierPlannedQtyActualQty
Supplier 18080
Supplier 18585
Supplier 22626
Supplier 33030
Supplier 35050

What I want to do in my script is to add a column in my QVD file as below -

IF PlannedQty >= 80 as Tray

IF PlannedQty <= 26 as Pallet

IF PlannedQty is > 26 and < 80 as Dollies

I then want to put Tray, Pallet and Dollies as ShipmentDescription.

#Thanks in advance!

1 Solution

Accepted Solutions
MVP
MVP

Re: If Statements in Script

May be this

If(PlannedQty <= 26, 'Pallet',

     If(PlannedQty < 80, 'Dollies', 'Tray')) as ShipmentDescription

1 Reply
MVP
MVP

Re: If Statements in Script

May be this

If(PlannedQty <= 26, 'Pallet',

     If(PlannedQty < 80, 'Dollies', 'Tray')) as ShipmentDescription

Community Browser