Start Date / End Date search

Wed, 25 Nov 2020 16:16:04 GMT

Hi, I have above table and it is not linked with any master calendar

and above are the lists of projects.

What I eventually want to do is to be able get all the amount of days spent for each project and get the estimate of each project.

for example, Let's say I want to know how many days has been spent on project C for the month of may.

Tosita Espinosa spent 31 days on the proejct and Lori Grimes spent 31 days and Tyreese spent 31 days. and each of them has different daily rate. So I want to be able to multiply the number of days each person spent on the project and multiply them by their daily rate and add them all up so that I can figure out how much we spent on project C for the month of may. I should figure out how to rule out weekends but that's for later.

my Start_Date and End_Date are not linked to any master data. so.. um... it's little complicate.

Please help!!

Re: Start Date / End Date search

sunny_talwar — Wed, 11 May 2016 01:38:30 GMT

Would you be able to share a sample with the expected output? Please look at the following links to learn about how to get a quick response to your question

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling‌

Uploading a Sample

Best,

Sunny

topic Start Date / End Date search in QlikView

Start Date / End Date search

Re: Start Date / End Date search