Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey, Guys,
I´m trying to have a master measure created via extension. I want the number format to be the standard format with format string "0,00%" (german layout), but it doesn´t work. I´m always getting a master measure with an empty number format string (correctly labeled as "Number" German: Zahl).
My parameters are:
"qNumFormat": {
"qType": F,
"qnDec": 2,
"qUseThou": 0,
"qFmt": 0,00%,
"qDec": , ,
"qThou": .
}
I´m sure it has something to do with the qFmt, but no matter how many single or double quotes i use, it still won´t accept it.
If i do the same with the money format, It works (meaning it shows my format string an the number type money.
How can I get qlik to give this measure the standard format for a %-number (I know there is a way to make it a user-defined format which ignores the given standard formats and uses the format string, but this isn´t what I want to achieve because it will erase the qlik-functionality of interpreting a number 0.1 as 10% (with a full custom number format it will give me 0.1%...).
Thanks for all your suggestions and thoughts!
Br Stephan
var properties = {
"qInfo": {
"qType": "measure",
"qId": measureId
},
"qMeasure": {
"qLabel": label,
"qDef": expression,
"qGrouping": "N",
"qLabelExpression": labelExpression,
"qExpressions": [],
"coloring": {
"baseColor": {
"color": color,
"index": -1
},
"gradient": segmentColor
},
"qActiveExpression": 0,
"qNumFormat": {
"qType": formatType,
"qnDec": parseInt(formatNDec),
"qUseThou": parseInt(formatUseThou),
"qFmt": formatFmt,
"qDec": formatDec,
"qThou": formatThou
}
},
"qMetaDef": {
"title": cells[0].qText,
"description": description,
"tags": tagsList,
}
};
Hi @goos_it , try to use this for creating your master measure. It will create a new master measure with your format
{
"qInfo": {
"qType": "measure",
"qId": "ZRPVLb"
},
"qMetaDef": {
"title": "Test Format 2",
"description": "",
"tags": []
},
"qMeasure": {
"qLabel": "Test Format 2",
"qDef": "sum(Expression2)",
"qLabelExpression": "",
"isCustomFormatted": false,
"qNumFormat": {
"qType": "F",
"qnDec": 2,
"qDec": ",",
"qThou": ".",
"qFmt": "0,00%"
},
"coloring": {}
}
}
This is what I have after I created the master measure with engine API