Discussion board where members can get started with QlikView.
Hi Everyone ,
I want to set flags for Order1,order2,order3
if ActualDispQty and ActualDispVol is NULL then
sum(VolBeingBilled) is Order1
if ActualDispQty has values
then sum(ActualDispQty )
if ActualDispQty and VolBeingBilled has values then
sum(ActualDispQty ) -sum(VolBeingBilled ) is Order3
If I understnad your requirement correctly.
A new flag field called Order is required with the three flag values (Order1, Order2, Order3) in the table for the above explained conditions.
Also can you provide us a sample excel data.
You are correct but i have only QVD.
Can you just share 10 rows if possible.
cusReqETA is date.
I couldnt attach the app hence script.
LOAD date(CustReqETA) as CustReqETA,
if((ActualDispQty =0 OR LEN(ActualDispQty)=0) and (ActualDispVol=0 OR LEN(ActualDispVol)=0),'Order1',
if(ActualDispQty>0 and (RecvdQty=0 OR RecvdQty=Null()),'Order2',
if(ActualDispQty>0 and VolBeingBilled>0,'Order3'))) as Order
(biff, embedded labels, table is Sheet1$);
Please let me know if you have any queries.