HyperCubeDef with Measures based of the Values from the Propertie-Panel

fduchmann — Mon, 13 Jun 2016 09:06:51 GMT

Hello Qlik Sense Community,

I am trying to create a Hypercube within a Qlik Sense Extension. Everything works fine when I define qDimensions and qMeasures with pre defined Fields.

For Example: (Note that "acitivtiy_id" and "counter" is the name of the columns)

var cubeDef = {

qDimensions: [{

qDef: {qFieldDefs: [activity_id] }

}],

qMeasures: [{

qDef: {

qDef: "=Sum(counter)",

}

}],

qInitialDataFetch: [{

qTop: 0,

qLeft: 0,

qHeight: 100,

qWidth: 2
}]

}

However, when I try to replace "counter" with a value from the Propertie-Panel it does not work for the qMeasures Definition.

qFieldDefs works as expected. But qMeasures--> qDef is always set to 0 in the Hypercube. If I print out the value with

console.log("Properties (Counter): ", layout.props.hcSection.hc1Counter); it gives me the right the value back.

var cubeDef = {

qDimensions: [{

qDef: {

qFieldDefs: [layout.props.hcSection.hc1ActivityID], /** This Works */

}

}],

qMeasures: [{

qDef: {

qDef: "=Sum(layout.props.hcSection.hc1Counter)", /** This doesn't work */

}

}],

qInitialDataFetch: [{

qTop: 0,

qLeft: 0,

qHeight: 100,

qWidth: 2
}]

}

Hope someone can help me.

Best regards Frank

Re: HyperCubeDef with Measures based of the Values from the Propertie-Panel

fduchmann — Thu, 16 Jun 2016 11:10:17 GMT

FYI

The Solution is realy simple if you know how Qlik Sense works:

qDef: layout.props.hcSection.hc1Counter // this is the reference to the Input field

In the propertie Tab just type " =Sum(counter) " and everything works fine.

Maybe this is helpfull for someone else.

topic Re: HyperCubeDef with Measures based of the Values from the Propertie-Panel in Integration, Extension & APIs

HyperCubeDef with Measures based of the Values from the Propertie-Panel

Re: HyperCubeDef with Measures based of the Values from the Propertie-Panel