Skip to main content

This lib allows you to integrate qlik with jupyter notebook.

Project description

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

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pytoqlik-0.0.9.tar.gz (7.7 kB view details)

Uploaded Source

Built Distribution

pytoqlik-0.0.9-py3-none-any.whl (9.6 kB view details)

Uploaded Python 3

File details

Details for the file pytoqlik-0.0.9.tar.gz.

File metadata

  • Download URL: pytoqlik-0.0.9.tar.gz
  • Upload date:
  • Size: 7.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/4.0.1 pkginfo/1.5.0.1 requests/2.24.0 requests-toolbelt/0.9.1 tqdm/4.47.0 CPython/3.8.3

File hashes

Hashes for pytoqlik-0.0.9.tar.gz
Algorithm Hash digest
SHA256 1eeb0426889c4e5600b519c267793a3bddccbe0aed66249c348980757b14f53a
MD5 e04c024f3821a5c270648aa762d05527
BLAKE2b-256 1d55a7326819d333f59fd07aedbbf699a24065b6b90fe8598dec14b623e90227

See more details on using hashes here.

File details

Details for the file pytoqlik-0.0.9-py3-none-any.whl.

File metadata

  • Download URL: pytoqlik-0.0.9-py3-none-any.whl
  • Upload date:
  • Size: 9.6 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.4.1 importlib_metadata/4.0.1 pkginfo/1.5.0.1 requests/2.24.0 requests-toolbelt/0.9.1 tqdm/4.47.0 CPython/3.8.3

File hashes

Hashes for pytoqlik-0.0.9-py3-none-any.whl
Algorithm Hash digest
SHA256 1eb41d1cb7146c056c2fbe3dba8d80e9fc18e8e9d93401525b1e10f26086a38f
MD5 32da176cc7e25bc36c48eece3b0dfeab
BLAKE2b-256 0c9242ecf6fca0dcf71483180f5e75d3732ccb18284612abfa072539e71dbb74

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page