Skip to main content
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