Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
EliGohar
Partner - Creator III
Partner - Creator III

HyperCube with Master Items (Dimensions, Measures)

Hi all,

I created a hyperCube using the mashup editor.

When I try to use a measure name from the application, I get no results.

For example:

 

qMeasures: [{
            qDef: {
                qDef: "# of Objects",
                qLabel: "# of Objects"
            }
        }]

 

"# of Objects" is a measure in my application which contains the following expression:

 

count( ObjectID)

 

If I change the qDef property to be "count( ObjectID)", then I get the expected results.

Is there a way/method to use the master items names from the application and not the fields names?

Thanks,

Eli.

Labels (2)
5 Replies
abhijith28
Creator II
Creator II

Hi Eligohar, 

Did you find any solution to use master measures in the hypercube to build the charts.

 

Thanks,

 

EliGohar
Partner - Creator III
Partner - Creator III
Author

@abhijith28  Unfortunately no solution since I've opened this post.

abhijith28
Creator II
Creator II

Even i am finding the solution. i guess this can be achieved by passing the Master measure id's into the hypercube

 

abhijith28
Creator II
Creator II

Hi,

Check the attachment. I guess you can create using this script.

Øystein_Kolsrud
Employee
Employee

You mean you want to use a master measure in your hypercube? In that case you should write like this:

qMeasures: [{ qLibraryId: "<object ID>"}]

The page below provides more information, but the important thing here is the note that states "Either qDef or qLibraryId must be set, but not both."

https://help.qlik.com/en-US/sense-developer/June2019/APIs/EngineAPI/definitions-NxMeasure.html