Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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

May be this

If(PlannedQty <= 26, 'Pallet',

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

View solution in original post

1 Reply

May be this

If(PlannedQty <= 26, 'Pallet',

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

View solution in original post