topic Re: .Net SDK to extract Master Dimensions and Measures from Qliksense Application in Integration, Extension & APIs

.Net SDK to extract Master Dimensions and Measures from Qliksense Application

sourabh808 — Sat, 16 Nov 2024 05:29:34 GMT

Hi,

I have connected to a particular Qliksense application and now am able to extract sheets, properties of each object on sheet.

Can anyone help to extract the Master Dimension and Measures from the application.

Thanks,

Sourabh

Re: .Net SDK to extract Master Dimensions and Measures from Qliksense Application

Prashant_Naik — Sat, 29 Jun 2019 17:29:13 GMT

Hi,

This might help you

https://community.qlik.com/t5/Qlik-Sense-Integration/QlikSense-Net-SDK-Retrieve-chart-dimensions-and-measure/td-p/1419262

create a Session object

{
"method": "CreateSessionObject",
"handle": 1,
"params": [
{
"qInfo": {
"qType": "MeasureList"
},
"qMeasureListDef": {
"qType": "measure",
"qData": {
"title": "/title",
"tags": "/tags"
}
}
}
],
"outKey": -1,
"id": 5
}

Same for Dimension too with following updates

"qInfo": {
"qType": "DimensionList"
},
"qDimensionListDef": {
"qType": "dimension",

and call for getlayout() function

{
"method": "GetLayout",
"handle": 2,
"params": [],
"outKey": -1,
"id": 4
}

you will get the list of measures and dimensions

Tip : Qlik Dev-hub will help you with the same steps i suggested you

Hope it will helpful 🙂

Regards,

Prashant

Re: .Net SDK to extract Master Dimensions and Measures from Qliksense Application

Øystein_Kolsrud — Sun, 30 Jun 2019 17:30:37 GMT

An example of how to list master measures can be found here:

https://github.com/kolsrud/qlik-dot-net-sdk-hypercube-usage/blob/master/HypercubeUsage/Program.cs#L109

Similar process for master dimensions...

Re: .Net SDK to extract Master Dimensions and Measures from Qliksense Application

Prashant_Naik — Sun, 30 Jun 2019 21:23:01 GMT

Hello,

This may also help you

https://community.qlik.com/t5/Qlik-Sense-Integration/Listing-master-items-using-NET-SDK/td-p/75668

Regards,

Prashant

Re: .Net SDK to extract Master Dimensions and Measures from Qliksense Application

sourabh808 — Fri, 05 Jul 2019 07:48:37 GMT

Thank you for your responses.

I was able to extract the master items, but i am now stuck how do we get the expressions for the particular master dimension/ measure.

Re: .Net SDK to extract Master Dimensions and Measures from Qliksense Application

Øystein_Kolsrud — Mon, 29 Jul 2019 08:03:57 GMT

Once you have opened the master dimension/measure, then you can access the definition through it's properties. Something like this:

var masterMeasure = app.GetGenericMeasure(<the id of the master measure>); var measure = masterMeasure.Properties.Measure; Console.WriteLine(measure.Def);