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

Related tags

Miscellaneous python pandas-dataframe jupyter-notebook pandas qlik qliksense
Overview

PTQ

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
You might also like...
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

rany 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. ##############

Bernardo Olisan 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

Maj Gaberšček 1 Nov 16, 2021
Opensource Desktop application for kenobi.
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

Aayush 9 Oct 8, 2022
Wunderland desktop wallpaper and Microsoft Teams background.
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

null 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

Omar 1 Dec 13, 2021
The presented desktop application was made to solve 1d schrodinger eqation
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

Artem Kashapov 2 Dec 29, 2021
Osu statistics right on your desktop, made with pyqt
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

Aditya Gupta 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

Nil Pujol 1 May 2, 2022
Comments
  • Sprint-wk-3 - Basic Qlik Cloud SaaS functionality

    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

    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
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

Eliaz Bobadilla 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

Pikatsuto 1 Mar 7, 2022
Scripts to integrate DFIR-IRIS, MISP and TimeSketch

Scripts to integrate DFIR-IRIS, MISP and TimeSketch

Koen Van Impe 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

TenderOwl 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

null 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

Matteo Guadrini aka GU 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

Jannik Ramrath 1 Feb 5, 2022
Anki for desktop computers

Anki This repo contains the source code for the computer version of Anki. If you'd like to try development builds of Anki but don't feel comfortable b

Ankitects 12.9k Jan 9, 2023
A simple desktop application to scan and export Genshin Impact Artifacts.

「天目」 -- Amenoma 简体中文 | English 「天目流的诀窍就是滴水穿石的耐心和全力以赴的意志」 扫描背包中的圣遗物，并导出至 json 格式。之后可导入圣遗物分析工具( 莫娜占卜铺 、 MingyuLab 、 Genshin Optimizer 进行计算与规划等。 已支持 原神2.

夏至 475 Dec 30, 2022
Comics/doujinshi reader application. Web-based, will work on desktop and tablet devices with swipe interface.

Yomiko Comics/doujinshi reader application. Web-based, will work on desktop and tablet devices with swipe interface. Scans one or more directories of

Kyubi Systems 26 Aug 10, 2022