topic How to extract QVD data using python in QlikView

How to extract QVD data using python

Wed, 25 Nov 2020 16:16:04 GMT

Is there any way to extract data from QVD file using python script.

**sorry i never worked on qlikview but we have a requirement to extract data from qlikview pertaining to some tool we are building.

Thanks a million in advance.

Re: How to extract QVD data using python

avinashelite — Tue, 29 Aug 2017 09:47:25 GMT

QVD are native qlik readable file .....it has 3 parts

XML header to describe the fields in the table, the layout of the subsequent information and other meta-data.
Symbol tables in a byte stuffed format.
Actual table data in a bit-stuffed format.

As per I know you could extract the meta-data information not sure about the actual data

Re: How to extract QVD data using python

marcus_malinow — Tue, 29 Aug 2017 09:53:00 GMT

Hi Prabhat,

given that QVD is a proprietary format, you're likely to run into difficulties. You might look instead into saving your data into QVX files, then reading those.

QlikView QVX File Format

https://community.qlik.com/message/92107#92107

Marcus

Re: How to extract QVD data using python

VasilyEvdokienko — Thu, 06 Dec 2018 07:46:25 GMT

Try this:

def qvd_to_pandas(src_qvd):

    from tempfile import TemporaryDirectory
    from pathlib import Path

    from win32com.client import Dispatch
    import pandas as pd

    with TemporaryDirectory(dir='.') as tmp_dir:
        tmp_csv = Path(tmp_dir).absolute() / 'tmp.csv'
        tmp_qvw = Path(tmp_dir).absolute() / 'tmp.qvw'

        script = f'''    
        ExportTable: REPLACE LOAD * FROM {Path(src_qvd).absolute()} (qvd);
        STORE ExportTable INTO {tmp_csv} (txt);
        DROP TABLE ExportTable;
        '''

        qv = Dispatch('QlikTech.QlikView')
        active_doc = qv.CreateDoc()

        doc_properties = active_doc.GetProperties()
        doc_properties.script = doc_properties.script + script

        active_doc.SetProperties(doc_properties)
        active_doc.SaveAs(tmp_qvw)
        active_doc.ReloadEx(0, 1)

        active_doc.CloseDoc()
        qv.Quit()

        df = pd.read_csv(open(tmp_csv, encoding='utf8'), dtype=str)

    return df

df = qvd_to_pandas('my_qvd_file.qvd')

Re: How to extract QVD data using python

IAMDV — Mon, 21 Jan 2019 07:49:26 GMT

You should attribute when you copy & paste the code.

Source:

https://stackoverflow.com/questions/46517656/import-qvd-file-into-jupyter-notebook-python2?rq=1

Re: How to extract QVD data using python

VasilyEvdokienko — Mon, 21 Jan 2019 09:03:08 GMT

Added attributes to my stackoverflow post. Thanks 😉

Re: How to extract QVD data using python

IAMDV — Mon, 21 Jan 2019 10:40:51 GMT

Lol! Nice situation to be in. I had a feeling that you are the same person. You see - I didn’t go too hard without knowing it. 😉

Does this only work on Windows OS? I tried on Mac OS and it doesn’t work.

Re: How to extract QVD data using python

VasilyEvdokienko — Mon, 21 Jan 2019 11:51:38 GMT

Integrity matters 🙂
Yes, only works on Windows. For Mac the solution may be in https://github.com/mattneub/appscript

Re: How to extract QVD data using python

thi_pham — Wed, 09 Oct 2019 07:20:58 GMT

I have an environment with Qlik sense only (no qlik view), how to make it work cause I always got error on the line:

Dispatch('QlikTech.QlikView')

Re: How to extract QVD data using python

ajbilimoria — Mon, 03 Feb 2020 10:26:01 GMT

Hi,

Thank you for this code, i tried to implement it and its working fine also but every time when its making communication, it opens Qlikview Desktop version for few seconds and close the same automatically.

Can we block that pop up?

Re: How to extract QVD data using python

mar_disdier — Thu, 18 Jun 2020 14:51:28 GMT

Hello @thi_pham

Did you find a solution to read qvd files with Qliksense ?

Thank you.

Marion

Re: How to extract QVD data using python

thi_pham — Fri, 19 Jun 2020 11:32:29 GMT

Hello @mar_disdier , I have no solution yet 😞

The python script above works with qlik view environment only.

Re: How to extract QVD data using python

mar_disdier — Fri, 19 Jun 2020 11:36:47 GMT

Too bad @thi_pham 😞 But thank you for letting me know!

Re: How to extract QVD data using python

fran_perea — Fri, 03 Feb 2023 08:42:25 GMT

This works better than the solution given:

https://pypi.org/project/qvd/

It´s easier

Re: How to extract QVD data using python

Surendra_Kakani1 — Wed, 14 Feb 2024 11:57:21 GMT

pip install qvd

from qvd import qvd_reader

df = qvd_reader.read('test.qvd')

print(df)...