topic Re: Show Current Project Activity in QlikView

Show Current Project Activity

Wed, 11 Mar 2015 12:46:27 GMT

We have a large display for our project team where we need to show all current project activity. I'm easily able to show the current days project activity based on the 'Project Task Start Date'. However, my expression is only pulling the Project Activity with current date and not project activity that may stretch over a week or a month.

Expression: =count(distinct {<ps_ID -= {1067, 1065, 1066}, PS_parent_task -= {'- None -'}, ps_resource -= {'Unassigned'}, ps_priority-={'Cancelled'}, ps_startdate={'$(=Today())'}>}ps_ID )

Example:

This currently shows per my expression based on 'Project Task Start Date'

Project ID	Project Coordinator	Project Parent Task	Project Task	Project Name	Project Task Start Date	Project Task End Date	Project Task Estimated Time	Project Task Actual Time	Project Task Status	Project Task Resource Name
263	Jessica Holcombe	- None -	Direct Certification File Import - Qty.1	HUDC01 Hudson City School District-OH : 263 186215 Hudson City School District-OH Rollover/Upgrade Service	3/9/2015	3/9/2015	1.5	1.5	Completed	- None -

I would also want to see this as a reference point since it extends over multiple days

Project ID	Project Coordinator	Project Parent Task	Project Task	Project Name	Project Task Start Date	Project Task End Date	Project Task Estimated Time	Project Task Actual Time	Project Task Status	Project Task Resource Name
1837	Lisa Warner	- None -	FOH On-Site, Support - 3/9 - 3/13	BREC01 Brevard County School Board : 1837 259115 Brevard County School Board Onsite Professional Service	3/9/2015	3/16/2015	50	16	Not Started	- None -

Re: Show Current Project Activity

Gysbert_Wassenaar — Wed, 11 Mar 2015 13:22:34 GMT

=count(distinct {<ps_ID -= {1067, 1065, 1066}, PS_parent_task -= {'- None -'}, ps_resource -= {'Unassigned'}, ps_priority-={'Cancelled'}, ps_startdate={'$(=Today())'}>}ps_ID )

Your expression will only show the projects with today's date as start date. That means that today neither 263 or 1837 are shown since both have the day before yesterday as start date. If I change your expression to show the projects with 3/9/2015 as start date then both 263 and 1837 are shown.

So, I guess I don't understand what you're actually asking. Can you try telling me again in more detail?

Re: Show Current Project Activity

Wed, 11 Mar 2015 13:58:12 GMT

Hi Gysbert,

When the day switches from 3/9 to 3/10 project 1837 does not show at all and doesn't show their after. Because it continues to be an active project, I would like for it to show WITH the project activity that is only scheduled on a day to day basis like project 263.

I want to see current days activity based on start date but also project activity that may extend beyond that original start date to get the full picture.

Does that help? I think I've confused myself!

Re: Show Current Project Activity

jonathandienst — Wed, 11 Mar 2015 14:07:39 GMT

This set expression fragment will get projects that start on or before today:

ps_startdate={"<=$(=Today())"}

You will also need a clause that excludes closed projects if that is not already present

HTH

Jonathan

Re: Show Current Project Activity

Gysbert_Wassenaar — Wed, 11 Mar 2015 14:14:25 GMT

Yes, that helps. As jontydkpi said you need to change the set modifier for the ps_startdate and perhaps add one for the ps_status field. Something like

=count(distinct {<ps_ID -= {1067, 1065, 1066},

PS_parent_task -= {'- None -'},

ps_resource -= {'Unassigned'},

ps_priority-={'Cancelled'},

ps_status-={'Completed'},

ps_startdate={'<=$(=Today())'}>}ps_ID )

But if you do want to see the processes that completed today too you'll need something like

=count(distinct {

<ps_ID -= {1067, 1065, 1066},

PS_parent_task -= {'- None -'},

ps_resource -= {'Unassigned'},

ps_priority-={'Cancelled'},

ps_startdate={'$(=Today())'}>

<ps_ID -= {1067, 1065, 1066},

PS_parent_task -= {'- None -'},

ps_resource -= {'Unassigned'},

ps_priority-={'Cancelled'},

ps_status-={'Completed'},

ps_startdate={'<$(=Today())'}>}ps_ID )