Qlik Functions Repository

May 21, 2024 ยท View on GitHub

Welcome to the Qlik Functions Repository! This repository contains a collection of custom functions for Qlik Sense and QlikView

Description

This project aims to provide a set of reusable functions for Qlik users to enhance their data modeling. The functions cover various categories, such as date and time processing, complex calculations, string manipulation, and more.

Function Covered

  • iTECSQLextract - to exract tables from a db
  • iTECVariableCreator - to create variables based on an excel file
  • iTEC_TimeReporting - creation of a time reporting table, the table contains easy selectable time periods
  • iTEC_MasterCalendar - creation of a master-default calendar
  • iTEC_ReloadTimeTracking - Creates a log File that tracks the load time per every call of the functions and save it in a file

Getting Started

Prerequisites

Before you can use these functions, ensure you have:

  • Qlik Sense Desktop or Qlik Sense Server
  • QlikView Desktop (for QlikView-specific functions)

Installation

To install the Qlik functions in your Qlik environment, follow these steps:

  1. Clone the repository or download the ZIP file.
  2. Open your Qlik application.
  3. Load the script file(s) containing the custom functions into your Qlik script.

Contributing

We welcome contributions to this project! If you have a custom function that you'd like to share, please follow these steps:

  1. Fork the repository.
  2. Create a new branch for your feature (git checkout -b feature/YourFeature).
  3. Commit your changes (git commit -am 'Add some feature').
  4. Push to the branch (git push origin feature/YourFeature).
  5. Open a new Pull Request.

Authors

Oliver Hartmann

Acknowledgments

Thanks to everyone who has contributed to this project! Special thanks to the Qlik community for the support and inspiration.