Upload Utility App - Qlik Community

SalmankojarMnM · ‎2025-08-19

Upload Utility App

Purpose of the app The Upload Utility app provides business users with a self-service way to upload and manage ad-hoc data files (mainly CSVs) that are not available in core systems like SAP. What it shows The app mirrors a three-level folder structure (Category → Sub-Category → KPI) from SharePoint into Qlik SaaS. Users select a folder from each level, and upon pressing the Fetch Files button, an automation is triggered that retrieves the file names from the chosen KPI folder. From this list, the user selects a file and uploads it into BigQuery, where it is stored along with the uploader’s name and timestamp. Users can also delete previously uploaded files through the same interface. Who uses it Multiple business stakeholders across functions use the app to independently contribute data specific to their KPIs, without requiring developer intervention. Value it’s having The app removes dependencies on IT teams, accelerates data availability, and empowers users to enrich dashboards with custom data. This has streamlined reporting processes, reduced turnaround time, and provided greater flexibility for business analysis.

Discoveries

Some of the discoveries from using this app include: Business users can easily upload and manage non-system data to enhance dashboards. Automated user and timestamp logging improved transparency and governance. KPI-based folder navigation made organizing and locating files much simpler. Quick upload/delete reduced delays and improved reporting efficiency. Developers were freed from repetitive manual uploads and could focus on higher-value work.

Impact

The app has empowered business teams with self-service data uploads, reduced dependency on IT, and accelerated reporting cycles. By making complete and reliable data quickly available in dashboards, it has improved both decision-making speed and confidence.

Audience

The app is primarily used by business stakeholders such as Deputy Managers, managers, analysts, and operations teams across different functions. It is accessed directly in Qlik SaaS and used frequently to upload KPI-specific data not available in core systems. Since multiple departments rely on it, the app has become an important enabler for timely reporting and analysis.

Data and advanced analytics

The app has empowered business teams with self-service data uploads, reduced dependency on IT, and accelerated reporting cycles. By making complete and reliable data quickly available in dashboards, it has improved both decision-making speed and confidence.