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: 
dsharmaqv
Creator III
Creator III

Calculate number of days

Hi

I have to calculate column "Days to Action" based "original Target date". Incase Original target date is revised then i need to consider "Revised Target Date".

Can some one assist me to achive this.

 

Original Target DateRevised Target DateDays to Action
12/01/2016-11
11/01/2016-41
11/01/201612/01/2016-5
11/01/201612/31/201625
12/31/201626
12/21/201616

 

Many thanks in advance

Deepak

1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi,

Please see attached.

Hope it helps!

View solution in original post

3 Replies
vinieme12
Champion III
Champion III

how do you calculate days to action? can you post complete sample in excel

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable

Hi,

Please see attached.

Hope it helps!

vinieme12
Champion III
Champion III

Try

=if(len(RevisedTargetDate)>0,RevisedTargetDate-Today(),OriginalTargetDate-Today())

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.