How to interface Python with Qlikview for data visualization?

python scikit-learn tableau-api qlikview
User456898 picture User456898 · May 3, 2016 · Viewed 7.3k times · Source

I am using Scikit-Learn and Pandas libraries of Python for Data Analysis. How to interface Python with data visualization tools such as Qlikview?

Answer

Waldo picture Waldo · Jun 14, 2016

There's no straightforward route to calling Python from QlikView. I have used this:

  1. Create a Python program that outputs CSV (or any file format that QlikView can read)
  2. Invoke your Python program from the QlikView script: EXEC python3 my_program.py > my_output.csv
  3. Read the output into QlikView: LOAD * FROM my_output.csv (...)

Note that the EXEC command requires the privilege "Can Execute External Programs" on the Settings tab of the script editor.

Related questions

How to normalize an array in NumPy?

I would like to have the norm of one NumPy array. More specifically, I am looking for an equivalent version of this function def normalize(v): norm = np.linalg.norm(v) if norm == 0: return v return v / norm Is there …

Read More
sklearn error ValueError: Input contains NaN, infinity or a value too large for dtype('float64')

I am using sklearn and having a problem with the affinity propagation. I have built an input matrix and I keep getting the following error. ValueError: Input contains NaN, infinity or a value too large for dtype('float64'). I …

Read More
ImportError: No module named sklearn.cross_validation

I am using python 2.7 in Ubuntu 14.04. I installed scikit-learn, numpy and matplotlib with these commands: sudo apt-get install build-essential python-dev python-numpy \ python-numpy-dev python-scipy libatlas-dev g++ python-matplotlib \ ipython But when I import these packages: from sklearn.cross_validation import train_test_…

Read More