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

Uploaded Source

Built Distribution

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

Uploaded Python 3

Supported by

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