topic Re: Flag in QlikView

Flag

deepakqlikview_123 — Mon, 31 Mar 2014 05:10:57 GMT

Hello Experts,

Can you pleas tell me ,

how the flag works in below expression

Flag&'-'&'FAB'&'-'&( if(((hour(MANUFACTURING_DATE)&':'&minute(MANUFACTURING_DATE)&':'&second(MANUFACTURING_DATE))>='07:00:00') and ((hour(MANUFACTURING_DATE)&':'&minute(MANUFACTURING_DATE)&':'&second(MANUFACTURING_DATE))<= '15:30:59'),1,
if(((hour(MANUFACTURING_DATE)&':'&minute(MANUFACTURING_DATE)&':'&second(MANUFACTURING_DATE))>='15:31:00') and ((hour(MANUFACTURING_DATE)&':'&minute(MANUFACTURING_DATE)&':'&second(MANUFACTURING_DATE))<= '23:59:59'),2,
if(((hour(MANUFACTURING_DATE)&':'&minute(MANUFACTURING_DATE)&':'&second(MANUFACTURING_DATE))>='00:00:01') and ((hour(MANUFACTURING_DATE)&':'&minute(MANUFACTURING_DATE)&':'&second(MANUFACTURING_DATE))<= '06:59:59'),3
)
))) as FabKey,

thanks,

Deepak

Re: Flag

its_anandrjs — Mon, 31 Mar 2014 05:25:09 GMT

This flag is working like

1.You have already a Flag field

2. then in that field you concate 'FAB' letter

3. after that you check MANUFACTURING_DATE for Hour Minute and Second combination like

if MANUFACTURING_DATE lies between >='07:00:00' and <= '15:30:59' then say 1 and

if MANUFACTURING_DATE lies between >='15:31:00' and <= '23:59:59' then 2 and

if MANUFACTURING_DATE lies between >='00:00:01' and <= '06:59:59' then 3

then your key like Flag-FAB-1 or Flag-FAB-2 or Flag-FAB-3

Hope this helps

Thanks & Regards

Re: Flag

jonathandienst — Mon, 31 Mar 2014 05:26:34 GMT

you can rewrite this:

Flag & '-' & 'FAB' & '-' &

(

if(Time(MANUFACTURING_DATE, 'hh:mm') <= '06:59'), 3

if(Time(MANUFACTURING_DATE, 'hh:mm') <= '15:30'), 1,

)

))) as FabKey,

Which should make it a little clearer.

HTH

Jonathan

Re: Flag

deepakqlikview_123 — Mon, 31 Mar 2014 05:27:39 GMT

Why we can use flag,can you please tell me some benefits of using flag in script

Re: Flag

its_anandrjs — Mon, 31 Mar 2014 05:33:34 GMT

1.If we want to get any filter for the application for selection

2.If we want to remove certain no of rows we are use flag.

3.For different date flags we are creating flag.

4.For bucket creation we are using flag.

Hope this helps

Thanks & Regards

Re: Flag

its_anandrjs — Mon, 31 Mar 2014 05:42:06 GMT

Hi,

Take a look for small example below has a table with 2 fields and SaleFlag is flag field created by any existing field

LOAD * Inline

[

ColA,Sales

A,1000

B,0

C,0

D,3000

];

LOAD

If(Sales = 0,'No Sales','Sales') as SaleFlag

Resident T;

DROP Table T;

Hope this helps

Thanks & Regards