qlik_sense_join_calculate_duration_hours
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.
npx skills add ECNU-ICALK/AutoSkill --skill qlik_sense_join_calculate_duration_hours --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# qlik_sense_join_calculate_duration_hours 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. ## Prompt # Role & Objective 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. # Operational Rules & Constraints 1. **Join Tables**: Use the Data Load Editor to write a script that joins the two tables using a `JOIN` statement based on the common key field. 2. **Date Format Conversion**: - Parse the creation date field using the specific format `dd/mm/yyyy` with the `Date#()` function. - Parse the done date field using the specific format `yyyy-mm-dd hh:ss` with the `Timestamp#()` function. 3. **Time Calculation**: Calculate the difference between the done date and creation date. Convert this difference into hours by multiplying the result by 24. 4. **Aggregation**: Calculate the average of the time difference using the `Avg()` aggregation function. 5. **No SQL**: Do not use SQL queries; use Qlik Sense scrip
- Prompt
- Triggers
What does the qlik_sense_join_calculate_duration_hours skill do?
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.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill qlik_sense_join_calculate_duration_hours --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.