topic Re: Create alert when timesheet not filled in QlikView

Create alert when timesheet not filled

isciberras — Tue, 30 Oct 2018 10:47:48 GMT

Hi all,

I'm currently bringing in data from a time sheet which specifies how long per day someone worked.

I was wondering if it would be possible to create an alert in the dashboard which specifies if someone did not fill in the timesheet?

The criteria would be something like looking back at a week to check if and if the sum of time is greater than 0.

Ideally I would then create an auto e-mail which is sent out if someone did not fill in the time sheet but I don't know if QlikView can do this.

Thanks,

Isaac

Re: Create alert when timesheet not filled

wade12 — Tue, 30 Oct 2018 10:53:16 GMT

one option is to create a flag in the script

if ( sum of time > 0, 'complete', 'incomplete') as timeflag

then use the flag as a filter on the front end

you can then select 'incomplete' in the filter and display all those employees that did not fill in their timesheets.

best wishes.

Re: Create alert when timesheet not filled

isciberras — Tue, 30 Oct 2018 11:51:12 GMT

Thanks Wade,

Thank you for your help I think that the code you sent over will look at time entered at any point in time so if a user enters the time in the time sheet one time then the condition will be satisfied, i'm hoping that the dashboard will check if the timesheet has been filled on a weekly basis, so if at the end of the week the user didn't fill in the timesheet then they will get an alert

Re: Create alert when timesheet not filled

wade12 — Tue, 30 Oct 2018 11:56:24 GMT

OK Isaac.

Best wishes.

Re: Create alert when timesheet not filled

jensmunnichs — Tue, 30 Oct 2018 12:08:10 GMT

Would it be possible for you to share your application? If necessary with dummy data?