Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

problem in converting excel formula into load editor

Hi, i have problem in converting the excel formula into load editor,

  =IF(EXACT(G2,""),"Not Started", IF(H2<=TODAY(),"Completed",IF(G2<=TODAY(),"In-Progress_Start",IF(F2<=TODAY(),"In-Progress_Tender",IF(E2="","Not Started",IF(E2<=TODAY(),"In-Progress_PEP","Not Started"))))))

Capture.PNG

This is what i have try, but there is error

IF("Start"=(''),('Not Started'),IF("End" =('<='TODAY()),('Completed'),IF("Start"=('<='TODAY()),('In-Progress_Start'),IF("Tender"=('<='TODAY()),('In-Progress_Tender'),IF("PEP"=(''),('Not Started'),IF("PEP"=('<='TODAY()),'(In-Progress_PEP'),('Not Started')))))) as "Status_try",


Thanks in AdvanceSmiley Happy

1 Solution

Accepted Solutions
undergrinder
Valued Contributor II

Re: problem in converting excel formula into load editor

Hi Lingling,

I think you are using more paranthesis, than it should be.

Try this:

IF("Start"='', 'Not Started',

       IF("End" <= TODAY(),'Completed',

            IF("Start" <= TODAY(),'In-Progress_Start',

                 IF("Tender"<= TODAY(),'In-Progress_Tender',

                      IF("PEP"='','Not Started',

                           IF("PEP" <= TODAY(),'In-Progress_PEP','Not Started')))))) as "Status_try",

G.

3 Replies
undergrinder
Valued Contributor II

Re: problem in converting excel formula into load editor

Hi Lingling,

I think you are using more paranthesis, than it should be.

Try this:

IF("Start"='', 'Not Started',

       IF("End" <= TODAY(),'Completed',

            IF("Start" <= TODAY(),'In-Progress_Start',

                 IF("Tender"<= TODAY(),'In-Progress_Tender',

                      IF("PEP"='','Not Started',

                           IF("PEP" <= TODAY(),'In-Progress_PEP','Not Started')))))) as "Status_try",

G.

Not applicable

Re: problem in converting excel formula into load editor

Thank you so much for your helpSmiley Happy

undergrinder
Valued Contributor II

Re: problem in converting excel formula into load editor

You're welcome

Community Browser