Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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
qlikdeez
Specialist
Specialist

Hi,

Please see attached.

Hope it helps!

View solution in original post

3 Replies
vinieme12
Champion II
Champion II

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

qlikdeez
Specialist
Specialist

Hi,

Please see attached.

Hope it helps!

View solution in original post

vinieme12
Champion II
Champion II

Try

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