Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kaldubai
Contributor

how to know what projects will finish in two week

Hello Everybody

i have been having a problem figuring out how to know what projects will finish  in two week  as my fields are as follow

StartingDate

ActualStartingDate

FinishingDate

ActualFinishingDate

PRO_ID

PRO_Name

Project_Precent_Compeleted

Many Thanks

1 Reply
mwoolf
Honored Contributor II

Re: how to know what projects will finish in two week

Maybe something like:

if((ActualFinishingDate-ActualStartingDate)<=13,1,0) as TwoWeekFlag

Community Browser