Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

Hi,

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

Regards

Anand