Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Ravindra
New Contributor

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
New Contributor

Re: New if Condition

 
Partner
Partner

Re: New if Condition

Try using if(match())

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

#OnVacation #BetweenJobs.
Please ekskuse my Norglish and Swenglish typos.