Can't find bad name in chart - suggestions?

QSDA Alpha
#1

I have a Quality flag - Dimension Syntax Error - that I cannot find in my Pivot chart. The name being flagged is bad - I used to use it, but it’s now retired. I can’t find it in sort, or anywhere else in the chart - suggestions? Maybe I should rebuild the chart?

image
image1242×510 21.2 KB

#2

Does this dimension name show up on the DImension view page? If so, can you post the info pop-up for it?

#3

Yes:

image
image1332×640 30.3 KB

#4

image
image1802×333 25 KB

#5

Click the i on the grid view and post the pop-up please.

image
image800×733 25.8 KB

#6

Got it now - here you go:

image
image999×831 38.6 KB

#7

Please extract and check the Pivot Table properties as follows:

  1. While on sheet containing the pivot table, add “/options/developer” to the end of the browser url and press Enter to reload.
  2. Right-click the pivot table, select “Developer” then “Properties”. That should open a json properties display for the object.
  3. Mark (Ctrl-a) and copy (Ctrl-c) the json.
  4. Paste in an editor and search for “Total Loan Costs Range”.

Did you find it? If so, can you paste it and several lines on either side?

#8

Yes, it’s there - I found it on at least one my pivots - here is the entire bracket enclosure it’s in:
{
“qLibraryId”: “”,
“qDef”: {
“qGrouping”: “N”,
“qFieldDefs”: [
“Total Loan Costs Range”
],
“qFieldLabels”: [
“”
],
“qSortCriterias”: [
{
“qSortByState”: 0,
“qSortByFrequency”: 0,
“qSortByNumeric”: 0,
“qSortByAscii”: 0,
“qSortByLoadOrder”: 1,
“qSortByExpression”: 0,
“qExpression”: {
“qv”: “”
},
“qSortByGreyness”: 0
}
],
“qNumberPresentations”: [],
“qReverseSort”: false,
“qActiveField”: 0,
“qLabelExpression”: “”,
“autoSort”: true,
“cId”: “NaLuDU”,
“othersLabel”: “Others”
},
“qNullSuppression”: false,
“qIncludeElemValue”: false,
“qOtherTotalSpec”: {
“qOtherMode”: “OTHER_OFF”,
“qOtherCounted”: {
“qv”: “10”
},
“qOtherLimit”: {
“qv”: “0”
},
“qOtherLimitMode”: “OTHER_GE_LIMIT”,
“qSuppressOther”: false,
“qForceBadValueKeeping”: true,
“qApplyEvenWhenPossiblyWrongResult”: true,
“qGlobalOtherGrouping”: false,
“qOtherCollapseInnerDimensions”: false,
“qOtherSortMode”: “OTHER_SORT_DESCENDING”,
“qTotalMode”: “TOTAL_OFF”,
“qReferencedExpression”: {
“qv”: “”
}
},
“qShowTotal”: false,
“qShowAll”: false,
“qOtherLabel”: {
“qv”: “Others”
},
“qTotalLabel”: {
“qv”: “”
},
“qCalcCond”: {
“qv”: “”
},
“qAttributeExpressions”: [],
“qAttributeDimensions”: [],
“qCalcCondition”: {
“qCond”: {
“qv”: “”
},
“qMsg”: {
“qv”: “”
}
},
“othersLabel”: “Others”
},