Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Ravindra
Contributor II
Contributor II

New if Condition

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.

 

 

Labels (1)
2 Replies
Ravindra
Contributor II
Contributor II
Author

 
Vegar
MVP
MVP

Try using if(match())

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes