Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.