Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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.

Highlighted
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.