topic Re: Flags in script in QlikView

Flags in script

ajsjoshua — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Flags in script

arasantorule — Mon, 04 Jul 2016 08:47:47 GMT

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.

Re: Flags in script

ajsjoshua — Mon, 04 Jul 2016 08:53:52 GMT

Hi arasantorule

You are correct but i have only QVD.

Regards,

Joshua.

Re: Flags in script

arasantorule — Mon, 04 Jul 2016 08:56:22 GMT

Can you just share 10 rows if possible.

Thanks.

Re: Flags in script

ajsjoshua — Mon, 04 Jul 2016 09:26:57 GMT

Hi,

PFA

Re: Flags in script

ajsjoshua — Mon, 04 Jul 2016 09:27:36 GMT

Hi,

cusReqETA is date.

Re: Flags in script

arasantorule — Mon, 04 Jul 2016 09:44:35 GMT

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.

Thanks.