Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Kohli
Contributor

IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'REJECT*'),'SOW Rejected',

May I know the meaning for this script::

IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'REJECT*'),'SOW Rejected',

    IF((NOT IsNull(PO_NUMBER) OR LEN(TRIM(PO_NUMBER)))<>0,'Project Completed',

    IF(Not Wildmatch(UPPER(SOW_APPROVAL_STATUS),'APPROVED'), 'SOW Acceptance Pending',

    IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'APPROVED')

    AND (ISNULL(RFQ_NO) OR LEN(TRIM(RFQ_NO))=0)

    ,'Sourcing Initiation Pending',

1 Reply
consultant_bi
Contributor

Re: IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'REJECT*'),'SOW Rejected',

Hello,


IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'REJECT*'),'SOW Rejected',

this line mean that if the field [SOW_APPROVAL_STATUS] on upper format have on it begining the word REJECT remplace it with the new value = 'SOW Rejected' 


-----------------------------------------------------------------------------------------------------------------------------------------------------
IF((NOT IsNull(PO_NUMBER) OR LEN(TRIM(PO_NUMBER)))<>0,'Project Completed',


this one mean that if the field [PO_NUMBER] is not null , have a value and not empty by testing the length of it and if it's <> to 0 , we gonna replace the value of the field [PO_NUMBER] by 'Project Completed'


-----------------------------------------------------------------------------------------------------------------------------------------------------

IF(Not Wildmatch(UPPER(SOW_APPROVAL_STATUS),'APPROVED'), 'SOW Acceptance Pending',


here we test if the value of the field [SOW_APPROVAL_STATUS] in upper format is not matching APPROVED we replace it by 'SOW Acceptance Pending'



-----------------------------------------------------------------------------------------------------------------------------------------------------

IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'APPROVED')
AND (ISNULL(RFQ_NO) OR LEN(TRIM(RFQ_NO))=0)    ,'Sourcing Initiation Pending',

the last lines means that if the field [SOW_APPROVAL_STATUS] in upper format is matching APPROVED and the other condition it's if the field [RFQ_NO] is null , have no value and empty by testing the length of it, if the conditions are confirmed we replace the value of the field [SOW_APPROVAL_STATUS] by Sourcing Initiation Pending


Community Browser