New if Condition

Ravindra — Sat, 16 Nov 2024 21:28:52 GMT

I have below code, I need to put a condition:

if INCO1 = DAP,CUP,UYP,UYT then [SSCP09 Overdue No of Days] = 10 Days otherwise 45 days

***********************************************************************************************************

Load [EBELN EBELP Key] as [SSCP09 EBELN EBELP Key],
[Target Quantity] as [SSCP09 Target Quantity],
[Target Date] as [SSCP09 Target Date],
[Target Date in System] as [SSCP09 Target Date in System],
INCO1 as [SSCP09 INCO1],
INCO2 as [SSCP09 INCO2],
[SSCPR05 Country Code] as [SSCP09 Country Code] ,
[SSCPR05 Vendor Name] as [SSCP09 Vendor Name],
EBELN as [SSCP09 EBELN],
EBELP as [SSCP09 EBELP],
BSART as [SSCP09 Document Type],
EKGRP as [SSCP09 EKGRP],
[Delivered Quantity] as [SSCP09 Delivered Quantity],
[Delivery Date] as [SSCP09 Delivery Date],
[SSCPR05 PO Status] as [SSCP09 PO Status],
[SSCP Date] as [SSCP09 SSCP Date],
[KPI Status] as [SSCP09 KPI Status],
[SSCPR05 Overdue No of Days] as [SSCP09 Overdue No of Days] ,
[SSCPR05 Pending Since Bucket] as [SSCP09 Pending since Bucket],
'XYZ' as [SSCP09 Company],
'XYZ' & Date([SSCP Date],'DD-MMM-YYYY') as %Link_SSCP09
from Test.qvd where wildmatch(HGPR,'800','801')<1;

Thanks in advance.

Re: New if Condition

Ravindra — Sun, 03 Feb 2019 08:57:32 GMT

Re: New if Condition

Vegar — Mon, 04 Feb 2019 05:12:29 GMT

Try using if(match())

if ( MATCH( INCO1 ,'DAP','CUP','UYP','UYT') , 10, 45) as [SSCP09 Overdue No of Days]

topic Re: New if Condition in QlikView

New if Condition

Re: New if Condition

Re: New if Condition