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: 
Not applicable

YTD for tasks on hand in table

Hi,

I need to create a Year to date to show the number of projects done by each staff.  I cannot get the expression correct.

Can anyone help to guide on this?

Thanks

Chun Wey

5 Replies
robert_mika
Master III
Master III

Can you attached sample of your data(not qvw)

Not applicable
Author

Hi Robert,

thanks for your help.

Attached is the data.

Chun Wey

robert_mika
Master III
Master III

From which table(tab) in Excel file the count should be taken?

There is 9 different tabs

Not applicable
Author

From the project tab, the count should be the no of project (p_id) done YTD.

Thanks for asking.

robert_mika
Master III
Master III

Create Straight Table.

Use p_id as Dimension  and below formula as Expresion:

count({<p_actualenddate={"<=$(=Date(Today(), 'MM/DD/YYYY')& '>=' & '01/01/2015')"}>} p_actualenddate)