topic Re: Help with qCalcCond on measure in Integration, Extension & APIs

Help with qCalcCond on measure

dselgo_eidex — Fri, 11 May 2018 17:15:08 GMT

Hello, I am trying to define a hyper cube, and I want to set a calculation condition on a measure. Right now I have the following:

"qMeasures": [

{

"qDef": {

"qLabel": "Foo",

"qGrouping": "N",

"qDef": "Bar",

"qNumFormat": {

"qType": "F",

"qnDec": 2,

"qUseThou": 0,

"qFmt": "0.0%",

"qDec": ".",

"qThou": ","

"autoSort": true,

"cId": "JXKjkd",

"numFormatFromTemplate": true,

"isCustomFormatted": false

"qSortBy": {

"qSortByNumeric": -1,

"qSortByLoadOrder": 1,

"qExpression": {}

"qCalcCond": {

"qv": "0"

"qCalcCondition": {

"qCond": {

"qv": "0"

"qMsg": {}

}

...

]

I have other measures in my hypercube definition, but I'm setting the calc condition of this one to 0 to see if I can get it to stop displaying.

I'm trying to create a pivot table with measures that will not calculate based on a variable I pass to qHyperCubeDef. However, when I set this measure to 0 to not calculate, the entire pivot table does not calculate. I get the following error in my console: "TypeError: Cannot read property 'qError' of undefined".

If I exclude "qCalcCond" and "qCalcCondition", the pivot table works fine, but it still displays the measure I don't want it to.

Am I just using qCalcCond wrong?

Re: Help with qCalcCond on measure

dselgo_eidex — Thu, 24 May 2018 21:17:28 GMT

Does anyone have any insight into this?

Re: Help with qCalcCond on measure

ajaykakkar93 — Mon, 01 Jul 2019 10:15:57 GMT

I am trying to find the same if i get a proper answer ill update.

Re: Help with qCalcCond on measure

jitu2110 — Thu, 20 Feb 2020 12:27:29 GMT

does anyone found any solution on this, i am also looking for same issue.

Re: Help with qCalcCond on measure

ajaykakkar93 — Sun, 15 Mar 2020 03:46:36 GMT

Hi,

ShowIf:{
type: "string",
label: "Show Column IF",
ref: "qCalcCondition.qCond.qv",
component: "expression"
}

Re: Help with qCalcCond on measure

dselgo_eidex — Mon, 16 Mar 2020 21:54:09 GMT

Wow I posted this a while ago. Since then I have been able to disable pivot table measures. I'm not sure if it is something that I did or if it was fixed in a patch or something, but I haven't had any issues doing this since I posted this question.

It might be that I was passing the number 0 when you need to pass the string "0", but I honestly don't remember if I had tried that when I posted this.

Re: Help with qCalcCond on measure

Akansha — Wed, 25 Mar 2020 03:52:23 GMT

Hi,

Can you please tell me how to give an expression in qCalcCond? I want to use this property to stop calculation of my hypercube if all of the given filters are not selected. Is it possible to write something like below in qCalcCond?

Getselectedcount(filter1)>=1 AND Getselectedcount(filter2)>=1

Could you help me with the syntax

Re: Help with qCalcCond on measure

dselgo_eidex — Wed, 25 Mar 2020 14:23:31 GMT

Try this:

"qCalcCond": { "qv": "=if(GetSelectedCount(filter1) >= 1 and GetSelectedCount(filter2) >= 1, 1, 0)" }, "qCalcCondition": { "qCond": { "qv": "" }, "qMsg": { "qv": "" } }

Re: Help with qCalcCond on measure

Akansha — Tue, 31 Mar 2020 07:05:48 GMT

not working still, tried with quotes, without quotes

return {
initialProperties: {
qHyperCubeDef: {
qDimensions: [],
qMeasures: [],
qInitialDataFetch: [{
qWidth: 50,
qHeight: 100
}],
qCalcCond: {
qv: "=GetSelectedCount(Currency) >= 1"
},
qCalcCondition: {
qCond: {
qv: ""
},
qMsg: {
qv: ""
}
}

}
},
definition: props,
snapshot: {
canTakeSnapshot: true
},

paint: function ( $element, layout ) {

.......