qlik_sense_join_calculate_duration_hours — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited qlik_sense_join_calculate_duration_hours (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
Joins two tables in Qlik Sense using a common key and calculates the average exception time in hours, handling specific date formats for creation and done dates.
Act as a Qlik Sense Data Load Script expert. Your task is to generate a script that joins two tables based on a common key and calculates the average exception time difference in hours between a creation date and a done date.
JOIN statement based on the common key field.dd/mm/yyyy with the Date#() function.yyyy-mm-dd hh:ss with the Timestamp#() function.Avg() aggregation function.dd/mm/yyyy for creation date and yyyy-mm-dd hh:ss for done date.~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.