Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Flags in script

Hi Everyone ,

I want to set flags for Order1,order2,order3

Order1

if  ActualDispQty and ActualDispVol is  NULL then

sum(VolBeingBilled) is Order1

:

Order2:

if  ActualDispQty has values

RecvdQty=NuLL

then sum(ActualDispQty )


Order3:

if  ActualDispQty and VolBeingBilled has  values then

sum(ActualDispQty ) -sum(VolBeingBilled )  is Order3

PFA

6 Replies
Highlighted
Creator III
Creator III

Re: Flags in script

Hi,

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.

Thanks.

Highlighted
Specialist
Specialist

Re: Flags in script

Hi arasantorule

You  are correct but i have only QVD.

Regards,

Joshua.

Creator III
Creator III

Re: Flags in script

Can you just share 10 rows if possible.

Thanks.

Highlighted
Specialist
Specialist

Re: Flags in script

Hi,

PFA

Highlighted
Specialist
Specialist

Re: Flags in script

Hi,

cusReqETA is date.

Highlighted
Creator III
Creator III

Re: Flags in script

Hi,

I couldnt attach the app hence script.

LOAD date(CustReqETA) as CustReqETA,

     ActualDispQty,

     ActualDispVol,

     RecvdQty,

     VolBeingBilled,

     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

FROM

(biff, embedded labels, table is Sheet1$);

Please let me know if you have any queries.

oRDER.PNG

Thanks.