Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

New field creation help

Hi Experts,

Can any one please help me on below requirement.

I have Two dates i.e, Start Date and End Date like below.

From these dates need to derive Leave Status column based on below condition

When End date is greater than Start Date then Leave Status need to show " Holiday booked and Taken"

When End date and Start date in null/Empty  then Leave Status need to show  "Holiday Not booked "

When Start date and End date are future dates from today  then Leave Status need to show "Holiday Booked"

Start Date                End Date                Leave Status

10/06/2018              16/06/2018              Holiday booked and Taken

-                              -                                Holiday Not booked    

14/07/2018             20/07/2018                Holiday Booked

Please help me on this.

Thanks in advance.

1 Reply
dapostolopoylos
Creator III
Creator III

Try this:


if(End Date > Start Date,

    " Holiday booked and Taken",

    if(IsNull(End Date) and IsNull(Start Date),

          "Holiday Not booked",

          if(End Date > Today() and Start Date > Today(),

              "Holiday Booked"

            )

        )

  )

Father/Husband/BI Developer