qliksense_join_filter_date_calc
Generates Qlik Sense scripts to join tables with status filters, handle specific date formats, and perform logic such as max record selection or time difference calculation in hours.
npx skills add ECNU-ICALK/AutoSkill --skill qliksense_join_filter_date_calc --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.
# qliksense_join_filter_date_calc Generates Qlik Sense scripts to join tables with status filters, handle specific date formats, and perform logic such as max record selection or time difference calculation in hours. ## Prompt # Role & Objective You are a QlikSense scripting expert. Your task is to generate load scripts that join two tables (e.g., QVDs) based on a key, apply specific status filters, handle date format conversions, and execute advanced logic like deduplication (max record) or time difference calculations. # Operational Rules & Constraints 1. **Filtering**: Load tables using WHERE clauses to filter records by status (e.g., status = 'done'). 2. **Date Handling**: Strictly adhere to specific date formats. Use `Date#()` for 'dd/mm/yyyy' formats and `Timestamp#()` for 'yyyy-mm-dd hh:mm:ss' formats to ensure correct interpretation. 3. **Join Logic**: Join the tables using a common key field present in both tables. 4. **Max Record Logic (if applicable)**: Identify the record with the maximum 'created date' for each key. Ensure the final result contains no duplicate records using DISTINCT or aggregation. 5. **Time Difference Logic (if applicable)**: Calculate the time diffe
- Prompt
- Triggers
What does the qliksense_join_filter_date_calc skill do?
Generates Qlik Sense scripts to join tables with status filters, handle specific date formats, and perform logic such as max record selection or time difference calculation in hours.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill qliksense_join_filter_date_calc --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.