Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Miles_Dyson
Contributor III
Contributor III

Autogenerating Workdates For Each Employee

I am new to qlik sense & i am building a practice dashboard to sharpen my skills. It is a 'Total hours worked' application & I would like some help on auto generating some dates as workdays for each employee (say a year's worth) as well s some random clock in & clock out times (say between 9am & 5pm) on each of the week days for each employee. I have some ideas on how this could be done but I don't have solid understanding yet on how to scrpt it accurately. I appreciate any help on this. Thank you.

Labels (6)
4 Replies
Rohan
Specialist
Specialist

Hi @Miles_Dyson ,

Check out the Intervalmatch() Function. This function would be a tailor made solution for your use case. Check out the below links for more information :

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

https://community.qlik.com/t5/Design/Using-IntervalMatch/ba-p/1475510

Regards,

Rohan.

vinieme12
Champion III
Champion III

there are a bunch of random data generators out there that would get this done

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
KD_
Contributor III
Contributor III

Thank you, I got a solution.

KD_
Contributor III
Contributor III

Thank you.