Export master dimension and measures

[Anjali_Raj16]

Hi Team,

How to export all the master dimensions and measures to an excel from a qliksense application.

Is it possible to achieve through API engine if yes please share how?

Thanks Anjali

[stevejoyce]

I used a qlik branch extension and it worked pretty nicely.  It also allows you to import into another app.  There was a bit of quirkiness on some objects exporting to excel when it began with an = sign, but you can add a tick to beginning of cell that have issues.  

It was very easy to setup and run, i only watched a few minute video.

https://github.com/GINQO/Master-Item-Manager

https://community.qlik.com/t5/Qlik-Sense-Documents/Introducing-The-GINQO-Master-Item-Manager/ta-p/15...

Or you can try to export from the API as well but this solution was good for what i wanted.

[rwunderlich · Accepted solution]

I can suggest a few options depending on your use case.  If you want to export on an adhoc basis, you can use an extension as @stevejoyce suggested, or use one of my favorites, Add Sense Chrome. 

If you want to point at an app, extract the Measures & Dimensions and then export to excel, try QSDA Pro.  Or perhaps you'll find that you don't need to export and you can do what you want from within QSDA. 

If you want to use a command line tool, you can use corectl . dimensions ls and measures ls commands. 

If you want to do it from within script, you could install qcb-qlik-sse and use GetDimensions / GetMeasures. BTW you can use https://github.com/RobWunderlich/qcb-qlik-sse/blob/master/lib/Qlik/QlikHelper.js as a code sample of one approach to get the data using engine api if you choose to write your own. 

-Rob

[Anjali_Raj16]

@rwunderlich Thanks for the options, I have tried with API engine.

[liuis]

You can also use a 'qsea' package for Python:

app.measures.df

returns the pandas dataframe with measure properties.

Same with dimensions and measures within specific objects (tables and charts) in the sheet.

https://pypi.org/project/qsea/