Filtering of activities in P6

Meurig 

Glad I could help you

Thanks for you help Zoltan. Your solution works perfectly.

Regards,

Meurig

Meurig

if you only want to find passing thru Jan 2020 then

filter 

all

where Start is less than Jan 1 2020

and 

finish is greater than Jan 31, 2020

also if you want activities that happen during Jan 2020 you will need to use 2 filters 

use the 1st one I listed and add a 2nd filter

any 

where start within the range Jan 1 2010 (low value) and Jan 31  2020 (high value)

or where where finish within the range Jan 1 2010 (low value) and Jan 31  2020 (high value) 

Kannan

filter

ANY where

start is within the range (low value) 8/1/201 and 8/31/2012 (high value)

or finish is within the range (low value) 8/1/201 and 8/31/2012 (high value)

I am looking to pass through January when it will be planned to be in progress.

Regards,

Meurig

Meurng

You have to at lest tell me what month you are looking to pass through ?

I think you are looking for 

activity status  equals in-progress

this will list any activities that have started but are not yet done.

Hi All,

How to fiilter the activities of a particular month, which neither starts nor ends in that particular month, but will be in progress stage during that month. 

eg:

All activities that fall within th date range 1st Jan to 31st Jan whether thay are planed to Start,Finish or pass through in Progress

Thanks in Advance

Meurig

Hi All,

How to fiilter the activities of a particular month, which neither starts nor ends in that particular month, but will be in progress stage during that month. 

eg:

All activities that fall within th date range 1st Jan to 31st Jan whether thay are planed to Start,Finish or pass through in Progress

Thanks in Advance

Robert, your solution is very good, as we say at home very much better!

BTW as far as I can recall MSP have such filter pre-defined under the name of Date Range Filter.

It doesn't matter much, but a slightly quicker way to filter for a particular period is;

Where Start is less than 31-Aug-12

And Finish is Greater than 01-Aug-12

I posted the p6 answer

How to filter the activities of a particular month, which neither starts nor ends in that particular month, but will be in progress stage during that month?

How in progress filter will find out if will be in progress a few months after Baseline DD?

In progress between Aug. 1, 2012  -  Aug. 31, 2012?

I am not a P6 user any longer but maybe the above can be specified, in such case it should be enough to make the filter.

I dont know what your data date is but here is a solution

solution #1

filter 

where

Paramenter       is                                   value                high value

start               is within the range of        aug 1, 2012       aug 31, 2012

or

Finish                is within the range of        aug 1, 2012       aug 31, 2012

or 

activity status              equals                     inprogress

Learn to use the operators, any activity that complies with Condition 1 OR Condition 2 OR Condition 3 OR Condition 4 will make it.

==>> Do not use AND operator.

BTW as long ago I stopped using Primavera each day it passes it becomes more difficult to understand it.

Hi rafael,

i want to filter the activities as condition 4 like you mentioned above. i did by puting start date greater than or equal to august 1 and finish date less than or equal to august 30. but its not showing all the activities. it is showing only finished activities. i need all activities within the range

best regards

hi,kannan,

open ur project, go to group & sort,group by select start , and  select a Month if group interval

and then apply, ok.

vty/Arneil

Hi

Can you explain how to working filter?

[[wysiwyg_imageupload:841:]]

This is how the Filter Coniditions given by Rafael would be in P6 and it works !!!

Regards

Shareef

Rafael's reply is the answer to any filter lookahead date problem

for your situation, condition 3

Filter specs should be:

All of the following

Start is less than or equals 01-Aug-12

Finish is greater than or equals 31-Aug-12

I do not use P6 but the following set of conditions can be a way:

• Condition 1: activities starting within the date range.
• Condition 2: activities finishing within the date range.
• Condition 3: activities starting before the date range and finishing after the date range.
• Condition 4: activities starting and finishing within the date range,

Learn to use the operators, any activity that complies with Condition 1 OR Condtition 2 OR Condition 3 OR Condition 4 will make it.

Best regards,

Rafael