Custom Properties for Measures

[richard_pearce6]

Hi All,

Slight issue retrieving a custom property for a measure..... My Example property.js Code is:

 var measures =

   uses: "measures",

    min: 0,

    items: {

        MyCheckProp: {

          type: "string",

          label: "Background color expression",

          ref: "qAttributeExpressions.0.qExpression",

          component: "expression",

        },

        BoolExample: {

          type: "boolean",

          label: "Percentage?",

          ref: "qAttributeExpressions.1.qExpression",

          defaultValue: false

        }

    } };

The extension shows both custom properties in Edit mode in QS. When I check the hypercube results I can only find the first (MyCheckProp) here at layout.qHyperCube.qMeasureInfo[0].qAttrExprInfo[0]

The second custom property (BoolExample) can't be found in the hypercube  I can only assume ref: "qAttributeExpressions.1.qExpression"  is incorrect (as its not an expression) although I've not been able to track down a solution on the help file

Help gratefully received. R

[ErikWetterberg]

Have you tried using component: ’expression’ ?

Might work, I haven’t tried. You might also need to set type to strong.

[Manoj_Prabu]

Hi @richard_pearce6 ,

In Qlik sense if you add any properties, then you have to cut the object and paste it again or delete the object and select dimension and measures from the beginning to show the qAttrExpr or qDef properly. 

Thank you.

[ajaykakkar93]

measures: {
				uses: "measures",
				min: 0,
				max: 30,
				items: {
					showIF:  {
						type: "string",
						label: "Show Column IF",
						ref: "qCalcCondition.qCond.qv", 
						component: "expression"
					},
					TotalAggr: {
						type: "string",
						label: "Total Function",
						ref: "qDef.qAggrFunc",
						component: "dropdown",
						options: [{
							value: "Expr",
							label: "Auto"
						},{
							value: "Avg",
							label: "Avg"
						}, {
							value: "Count",
							label: "Count"
						}, {
							value: "Min",
							label: "Min"
						}, {
							value: "Max",
							label: "Max"
						}, {
							value: "Sum",
							label: "Sum"
						},{
							value: "None",
							label: "None"
						}]
					},
					info: {
						label: "Add all the below as string(='color | bdcolor | textalign | header bgcolor | header color')",
						component: "text"
					},
					textcolor: {
						type: "string",
						ref: "qAttributeExpressions.0.qExpression",
						label: "Text Color",
						//expression: "always",
						component: "expression",
						defaultValue: "='#000'"
					},
					}}

I hope this helps you Or can refer to the file attached.
When you add a custom property I suggest to delete the object from the sheet and refresh the page, Add the object back again to look at changes.