If you've Date field in your Fact, you can link it to Master Calendar.
Usually it is by DateID
Maybe you can use the below in both Master Calendar and your Fact...
trim(date(TempDate,'YYYYMMDD')) as [DateID],
trim(date(YourDateFieldHere,'YYYYMMDD')) as [DateID],
Note: Tempdate is a field you'll pre define in your Master Table
Something like this...
$(varMinDate) + Iterno()-1 as Num,
Date($(varMinDate) + IterNo() - 1) as TempDate
AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);
and the variables in Temp table are also predefined, basically it's a Master Calendar.
It won't matter if a single employee has 1 recorded date or 100.
And same for multiple records for single date.
If 10 fields have same date, each field will show it's related date (which can be same date or different date) but if the fields change the date also changed.
Field1 Field2 Field3 Field4 Date
ABC, BCD, CDE, EFG, 03-26-2017
So if you take only Field1 and Date field, you'll get
Each record will have it's own date as the value is different in fields.
But if you consider it vise versa, Single date will be linked to all the values.
Maybe I'm wrong but cannot say for sure unless you can provide with the sample data and the result you looking for.
Not necessarily link target dates. Our reps will have multiple transactions in a day, so at the basic level what I need to do is be able to do is create a table in Qlik Sense that allows me to list staff, their position, their current sales, and their cumulative target based on the number of work days(i.e Month of March).
Currently my Target table is set up like below:
Position: Daily Target
Sales Rep 100
Sr Sales Rep 300
I will mention that the post you suggested did help with another piece of what I am working on, so thank you!!!