topic Re: If Else Condition in QlikView

If Else Condition

Mon, 02 Mar 2015 03:29:46 GMT

Dear all,

I have two date fields PO_DATE and INVOICE_DATE.. Now i wants to write a expression for two fields. My logic is below. How can i implement my logic using "IF Else " statement.

If PO_DATE=INVOICE_DATE then "Online" elseif interval(PO_DATE-Invoice_DATE,'DD') >=2 then 'twodays' elseif interval(PO_DATE-Invoice_DATE,'DD') >=10 then 'Tendays' else interval(PO_DATE-Invoice_DATE,'DD') >=30 then "Thirtydaysmore"

Regards,

Masba

Re: If Else Condition

Anonymous — Mon, 02 Mar 2015 07:13:23 GMT

If( PO_DATE = INVOICE_DATE , " Online" , if ( interval(Invoice_DATE - PO_DATE,'DD') <=2, "2daysmore", if (interval(Invoice_DATE - PO_DATE,'DD') <=10, " 10daysmore", if (interval(Invoice_DATE - PO_DATE,'DD') <=30, "30daysmore", "30daysmore") ) ) )

Re: If Else Condition

anbu1984 — Mon, 02 Mar 2015 07:29:07 GMT

If(PO_DATE=INVOICE_DATE,"Online",

if(interval(PO_DATE-Invoice_DATE,'DD')>=30 ,"Thirtydaysmore",

if(interval(PO_DATE-Invoice_DATE,'DD') >=10, 'Tendays' ,

if(interval(PO_DATE-Invoice_DATE,'DD') >=2 , 'twodays' ))))

Re: If Else Condition

er_mohit — Mon, 02 Mar 2015 07:44:14 GMT

For that first of all The date format for both date fields must same, then need to use number format for both date fields using either Floor or Num function . Doing this way it becomes easily to match the date between two fields.

After doing this use your if else Statement like below

If(Floor(Date(PO_DATE))=Floor(Date(INVOICE_DATE)),'Online',

if(Floor(Date(PO_DATE))-Floor(Date(Invoice_DATE)) >=2 , 'Twodays' ,

if(Floor(Date(PO_DATE))-Floor(Date(Invoice_DATE)) >=10, 'Tendays',

if(Floor(Date(PO_DATE))-Floor(Date(Invoice_DATE))>=30 ,'Thirtydaysmore'

))))

Hope it helps

Regards

Mohit

Re: If Else Condition

Anonymous — Mon, 02 Mar 2015 08:19:24 GMT

in ur case.. 5, 11 , 30 also greater than 2 so loop will not go to >=10 and >=30 cases..it ll come out at >=2 and result would be 2days more....sorry if I am wrong.....

Re: If Else Condition

jonathandienst — Mon, 02 Mar 2015 08:21:38 GMT

Mohit's statement is correct, except for the order of the Ifs:

If(Floor(Date(PO_DATE))=Floor(Date(INVOICE_DATE)), 'Online',

if(Floor(Date(PO_DATE))-Floor(Date(Invoice_DATE)) >= 30 ,'Thirtydaysmore',

if(Floor(Date(PO_DATE))-Floor(Date(Invoice_DATE)) >= 10, 'Tendays',

if(Floor(Date(PO_DATE))-Floor(Date(Invoice_DATE)) >= 2 , 'Twodays'

))))

HTH

Jonathan