topic IF condition in the script in QlikView

IF condition in the script

Fri, 22 Jun 2012 21:57:20 GMT

How can I use If condition in the script when I have the situation below?

I need to show the Qty fild only if I have the 'Y' in the Trans field .

The problem is the Trans field is from the Order table and the Qty fild is from the OrderDetail table.

Order:
LOAD
Pedido      as Order,
DtPedido as OrderDate,
CGC as Customer,
Represen as Rep,
Trans
FROM (qvd);

OrderDetail:
LOAD
Pedido      as Order,
Modelo      as Produc

Qty
// if (Trans = 'Y', Qty) as Order_Qty
FROM (qvd);

Best Regards,

Rodrigo

Re: IF condition in the script

robertomontanar — Fri, 22 Jun 2012 22:37:52 GMT

There are more than one solution; I like solutions: a)-easy to understand, b)-fast in reload.

This is my suggestion:

Order:
LOAD
Pedido as Order,
DtPedido as OrderDate,
CGC as Customer,
Represen as Rep,
Trans

,if (Trans = 'Y', Pedido) as TransOrder // add a new field with "Trans" Orders only

FROM (qvd);

OrderDetail:
LOAD
Pedido as Order,
Modelo as Produc

,if(exists(TransOrder,Pedido),Qty) as Order_Qty // fill the Qty for "Trans" Orders

FROM (qvd);

You like ?

Roberto

Re: IF condition in the script

Sat, 23 Jun 2012 13:43:49 GMT

Thanks for you reply Roberto. I liked very much!