Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I'm working on a mashup on qliksense v 2.0.4 and the idea is create a cube based on a previous table already build in the application.
I'm getting the layout or properties using the respective mashup API's. So I open the app then get the properties and take the layout json definition. Everything is alright, but when I've got the json result object on gGroupFielDefs section is displaying the fields without the set expressions; set expressions defined in the app. So when I've tried to place that definitions in the new cube is failing.
The Fields on the app are:
Dimensions:
Label: Word
Field Definition: Aggr(Only({<FreeTextQuestionUniqueId = {'{35563651-BFBC-40C7-BC1D-01D6BC193A43}'}, PrevDayStarted = {1}>} ResponseWord ), ResponseWord)
When I've getting the info on the mashup the qGroupFiledDefs is:
"qGroupFieldDefs": [
"=Aggr(Only({} ResponseWord ), ResponseWord)"
]
As you can see no set expression between {} as was defined in the app: <FreeTextQuestionUniqueId = {'{35563651-BFBC-40C7-BC1D-01D6BC193A43}'}, PrevDayStarted = {1}>
When I've gotten using the workbench I'm getting something like:
"qDimensionInfo": [
{
"qFallbackTitle": "Word",
"qApprMaxGlyphCount": 15,
"qCardinal": 114,
"qSortIndicator": "A",
"qGroupFallbackTitles": [
"Word"
],
"qGroupPos": 0,
"qStateCounts": {
"qLocked": 0,
"qSelected": 0,
"qOption": 0,
"qDeselected": 0,
"qAlternative": 0,
"qExcluded": 0,
"qSelectedExcluded": 0,
"qLockedExcluded": 0
},
"qTags": [],
"qDimensionType": "D",
"qGrouping": "N",
"qNumFormat": {
"qType": "U",
"qnDec": 10,
"qUseThou": 0
},
"qIsAutoFormat": true,
"qGroupFieldDefs": [
"=Aggr(Only({} ResponseWord ), ResponseWord)"
],
"autoSort": true,
"cId": "jDhVNCJ",
"othersLabel": "Others",
"textAlign": {
"auto": true,
"align": "left"
}
}
]
The same issue. No set expressions.
What I'm doing wrong? ... Do I need call another function mashup API in order to get the full expression?
I really appreciate your help!
Jose
Layout and properties are two different structures: properties contains expressions etc, while layout contains the calculated values. For rendering you need layout, and your json looks like the layout, but in your case you would need to get the properties.
Erik
Thanks Erik for your quickly answer
Unfortunately, I'm getting the same result with the properties. A chunk below:
{
"jsonrpc": "2.0",
"id": 3,
"result": {
"qProp": {
"qInfo": {
"qId": "YMqmSP",
"qType": "table"
},
"qMetaDef": {},
"qHyperCubeDef": {
"qDimensions": [
{
"qDef": {
"qGrouping": "N",
"qFieldDefs": [
"=Aggr(Only({} ResponseWord ), ResponseWord)"
],
"qFieldLabels": [
"Word"
],
"qSortCriterias": [
{
"qSortByLoadOrder": 1,
"qExpression": {}
}
],
"qNumberPresentations": [],
"qActiveField": 0,
"autoSort": true,
"cId": "jDhVNCJ",
"othersLabel": "Others",
"textAlign": {
"auto": true,
"align": "left"
}
},
"qNullSuppression": true,
"qOtherTotalSpec": {
"qOtherMode": "OTHER_OFF",
"qOtherCounted": {
"qv": "10"
},
"qOtherLimit": {
"qv": "0"
},
"qOtherLimitMode": "OTHER_GE_LIMIT",
"qForceBadValueKeeping": true,
"qApplyEvenWhenPossiblyWrongResult": true,
"qOtherSortMode": "OTHER_SORT_DESCENDING",
"qTotalMode": "TOTAL_OFF",
"qReferencedExpression": {}
},
"qOtherLabel": {},
"qTotalLabel": {},
"qCalcCond": {}
}
]
....
Looks like a bug, please report it.
Erik