Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to calculated worked days, displayed over different months

Hi there,

I have a table containing a "billing month", a startdate of the projects and the enddate.

Now I would like to calculate the days somebody has been working on a projects. So when somebody starts the 15the of jan and ends the 20the of feb. I want to see a bar chart with 2 different values for jan and feb.

How can i accomplish this? Thanx a lot!

1 Reply
its_anandrjs
Champion III
Champion III

Hi,

You need to find out the Day of the date field like Day(DateColumn) and then use it as Dimension.

Regards

Anand