topic Export entire Qlik Sense data model to Excel in App Development

Export entire Qlik Sense data model to Excel

consenit — Fri, 24 Nov 2017 15:39:59 GMT

Hello folks.

We have a Qlik Sense application in QVF format and would like to export all the tables in the data model. We tried creating one table objects per table but the key fields are hidden with SET HidePrefix ='%' in the script and therefore not selectable. Obviously we cannot reload the application because the original data source is not available.

Is there a way to extract all tables from the QFV alone?

Thanks in advance.

Kind regards,

Ernesto.

Re: Export entire Qlik Sense data model to Excel

avkeep01 — Fri, 24 Nov 2017 15:48:15 GMT

Hi Ernesto, you could use this script in a new qvf

BINARY [Location/application.qvf];

/// STORE in different folders

// Location datamart

SET vDatamart = \\02 - Content\06 - Models\Datamarts;

FOR i = 0 TO NUM(NOOFTABLES()-1);

IF TABLENAME($(i)) = 'Calender' THEN

// Don't store the calendar
LET i= $(i)+1;

ELSE

LET vTable = TABLENAME($(i));

STORE '$(vTable)' INTO '$(vDatamart)\$(vTable).qvd' (qvd);

END IF

NEXT i

Re: Export entire Qlik Sense data model to Excel

petter — Fri, 24 Nov 2017 15:52:04 GMT

Yes there is.

You can do a BINARY load of the existing Qlik Sense application in a new Qlik Sense application's load script. Then you add one STORE statement for every table in the data model.

This can be done dynamically as you have special meta-data tables in Qlik that has the names of the tables in memory. This system table is called $Table. System fields ‒ Qlik Sense

Re: Export entire Qlik Sense data model to Excel

consenit — Fri, 24 Nov 2017 17:31:48 GMT

Thank you very much for you response, that worked like a charm.

Kind regards,

Ernesto.