PyToQlik is a library that allows you to integrate Qlik Desktop with Jupyter notebooks

Last update: Sep 9, 2022

Overview

PyToQlik

PyToQlik is a library that allows you to integrate Qlik Desktop with Jupyter notebooks. With it you can:

Open and edit a Qlik app inside a Jupyter notebook;
Create a Qlik object with data from a pandas DataFrame data structure and/or;
Import data from a Qlik object and create a pandas DataFrame to work with in Python.

Getting Started

For this library to work you must have a functioning Qlik Desktop App installed and running on your local machine. You will also need to have the pandas library and a Jupyter Notebook local server (read https://jupyter.readthedocs.io/en/latest/running.html).

You can then download and install PyToQlik using:

Installation

pip install pytoqlik

Usage

Example 1

Creating a Qlik app and feeding it data

from pytoqlik import Pytoqlik
import seaborn

df = seaborn.load_dataset('tips')  # df is just some example data provided by the seaborn library

p2q = Pytoqlik()
app = p2q.toQlik(df)

Example 2

Importing data from a Qlik object to Python

from pytoqlik import Pytoqlik
import seaborn

df = seaborn.load_dataset('tips')  # df is just some example data provided by the seaborn library

p2q = Pytoqlik()
app = p2q.toQlik(df)
app.toPy('your ObjectID')

Step by step guide

Documentation

Current documentation can be found here.

Current limitations

PyToQlik is currently implemented for QlikSense Desktop versions. Cloud and Enterprise versions of Qlik are still in active development.

Features in development

Connectivity

Qlik Enterprise support
Qlik Cloud support

Functionality

Data fetching based on dimensions and measures
More robust embedding objects and sheets
More robust script editing
Object creation and manipulation via Python
Auxiliary functions, app listing and object listing
Task creation and managing
ETL features in Python

Install Firefox from Mozilla.org easily, complete with .desktop file creation.

firefox-installer Install Firefox from Mozilla.org easily, complete with .desktop file creation. Dependencies Python 3 Python LXML Debian/Ubuntu: sudo

7 Nov 4, 2022

An Airdrop alternative for cross-platform users only for desktop with Python

PyDrop An Airdrop alternative for cross-platform users only for desktop with Python, -version 1.0 with less effort, just as a practice. ##############

6 Mar 25, 2022

A python script that changes your desktop background based on current weather and time of the day.

Desktop background wallpaper, based on current weather and time A python script that changes your computer's desktop background based on current weath

1 Nov 16, 2021

Opensource Desktop application for kenobi.

Kenobi-Server WIP Opensource desktop application for Kenobi. Download the apple watch app to get started. What is this repo? It's repo for the opensou

9 Oct 8, 2022

Wunderland desktop wallpaper and Microsoft Teams background.

Wunderland Professional Impress your colleagues, friends and family with this edition of the "Wunderland" wallpaper. With the nostalgic feel of the or

3 Dec 14, 2022

A docker container (Docker Desktop) for a simple python Web app few unit tested

Short web app using Flask, tested with unittest on making massive requests, responses of the website, containerized

1 Dec 13, 2021

The presented desktop application was made to solve 1d schrodinger eqation

schrodinger_equation_1d_solver The presented desktop application was made to solve 1d schrodinger eqation. It implements Numerov's algorithm (step by

2 Dec 29, 2021

Osu statistics right on your desktop, made with pyqt

Osu!Stat Osu statistics right on your desktop, made with Qt5 Credits Would like to thank these creators for their projects and contributions. ppy, osu

21 Jul 13, 2022

A refresher for PowerBI Desktop documents

PowerBI_Refresher-NPP Informació Per executar el programa s'ha de tenir instalat el python versio 3 o mes. Requeriments a requirements.txt. El fitxer

1 May 2, 2022

Comments

Sprint-wk-3 - Basic Qlik Cloud SaaS functionality

Added support (and tutorials!) for how to connect and work with Qlik Cloud SaaS version. Extract, import and/or modify data in an application inside your tenant in Qlik Cloud!

opened by BeautyFades 0
Patch sprint week1

toPy: now works dinamically (no more reloading/reopening apps) now works for dashboards with multiple objects by grabbing the object handle correctly returns dataframes correctly when no measures/no dimensions are selected in an object now returns dataframe dimensions as expected now handles HyperCube sizes to limit it to a single Qlik data page (dimension * measure <= 10000) improved verbose and error handling

new function: listApps() lists all apps inside Qlik's folder. returns name, path and file size

openApp: improved verbose data and error handling now works correctly with sheetName

toQlik: now works for any number of dataframes you want to input composes a script for all datasets inside a single Qlik script added configurable separator for dataframe to csv files

Other: improvements in readability, minor changes to organize code

opened by BeautyFades 0

Owner

BIX Tecnologia

GitHub

🛠️ Plugin to integrate Chuy with Poetry

Archived This is bundled with Chuy since v1.3.0. Poetry Chuy Plugin This plugin integrates Chuy with Poetry. Note: This only works in Poetry 1.2.0 or

4 Sep 24, 2021

A code base for python programs the goal is to integrate all the useful and essential functions

Base Dev EN This GitHub will be available in French and English FR Ce GitHub sera disponible en français et en anglais Author License Screen EN ???? D

1 Mar 7, 2022

Scripts to integrate DFIR-IRIS, MISP and TimeSketch

20 Dec 16, 2022

The only purpose of a byte-sized application is to help you create .desktop entry files for downloaded applications.

Turtle ?? The only purpose of a byte-sized application is to help you create .desktop entry files for downloaded applications. As of usual with elemen

14 Dec 29, 2022

A plugin for poetry that allows you to execute scripts defined in your pyproject.toml, just like you can in npm or pipenv

poetry-exec-plugin A plugin for poetry that allows you to execute scripts defined in your pyproject.toml, just like you can in npm or pipenv Installat

38 Jan 6, 2023

pyreports is a python library that allows you to create complex report from various sources

pyreports pyreports is a python library that allows you to create complex reports from various sources such as databases, text files, ldap, etc. and p

78 Dec 13, 2022

TextColor - An easy to use Python library which allows you to make your terminal outputs more colorful and therefore easier to read and understand

This is an easy to use Python library which allows you to make your terminal out

1 Feb 5, 2022