# Can't find bad name in chart - suggestions?

**URL:** https://community.easyqlik.com/t/cant-find-bad-name-in-chart-suggestions/55
**Category:** QSDA Alpha
**Created:** [April 17, 2021, 3:56pm UTC](https://community.easyqlik.com/t/cant-find-bad-name-in-chart-suggestions/55 "2021-04-17T15:56:02Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![goliven](https://community.easyqlik.com/letter_avatar_proxy/v4/letter/g/5e9695/32.png) [@goliven](https://community.easyqlik.com/u/goliven)
#### Post date: [April 17, 2021, 3:56pm UTC](https://community.easyqlik.com/t/cant-find-bad-name-in-chart-suggestions/55/1 "2021-04-17T15:56:02Z")

</div>

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](https://easyqlik.discoursehosting.net/uploads/db5932/original/1X/44cda798dc6ca8140e0fd92eefb2d1c6db849f7f.png)

---

<div class="post-metadata">

### Author: ![rob](https://community.easyqlik.com/user_avatar/community.easyqlik.com/rob/32/8_2.png) [@rob](https://community.easyqlik.com/u/rob)
#### Post date: [April 18, 2021, 2:35pm UTC](https://community.easyqlik.com/t/cant-find-bad-name-in-chart-suggestions/55/2 "2021-04-18T14:35:56Z")

</div>

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

---

<div class="post-metadata">

### Author: ![goliven](https://community.easyqlik.com/letter_avatar_proxy/v4/letter/g/5e9695/32.png) [@goliven](https://community.easyqlik.com/u/goliven)
#### Post date: [April 18, 2021, 7:26pm UTC](https://community.easyqlik.com/t/cant-find-bad-name-in-chart-suggestions/55/3 "2021-04-18T19:26:10Z")

</div>

Yes:

 ![image](https://easyqlik.discoursehosting.net/uploads/db5932/original/1X/89075c9032584aecea77d40fad7801962630ed2d.png)

---

<div class="post-metadata">

### Author: ![goliven](https://community.easyqlik.com/letter_avatar_proxy/v4/letter/g/5e9695/32.png) [@goliven](https://community.easyqlik.com/u/goliven)
#### Post date: [April 18, 2021, 7:27pm UTC](https://community.easyqlik.com/t/cant-find-bad-name-in-chart-suggestions/55/4 "2021-04-18T19:27:15Z")

</div>

![image](https://easyqlik.discoursehosting.net/uploads/db5932/original/1X/21ab29ac2bfee900aaa75dd12835707da302b94d.png)

---

<div class="post-metadata">

### Author: ![rob](https://community.easyqlik.com/user_avatar/community.easyqlik.com/rob/32/8_2.png) [@rob](https://community.easyqlik.com/u/rob)
#### Post date: [April 18, 2021, 10:05pm UTC](https://community.easyqlik.com/t/cant-find-bad-name-in-chart-suggestions/55/5 "2021-04-18T22:05:19Z")

</div>

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

 ![image](https://easyqlik.discoursehosting.net/uploads/db5932/original/1X/c1bbffd2bdb88b634d084f39a09773a1979608a2.png)

---

<div class="post-metadata">

### Author: ![goliven](https://community.easyqlik.com/letter_avatar_proxy/v4/letter/g/5e9695/32.png) [@goliven](https://community.easyqlik.com/u/goliven)
#### Post date: [April 18, 2021, 10:54pm UTC](https://community.easyqlik.com/t/cant-find-bad-name-in-chart-suggestions/55/6 "2021-04-18T22:54:23Z")

</div>

Got it now - here you go:

 ![image](https://easyqlik.discoursehosting.net/uploads/db5932/original/1X/0ea5aa5c330c150469a2e59373d9e643f5955b59.png)

---

<div class="post-metadata">

### Author: ![rob](https://community.easyqlik.com/user_avatar/community.easyqlik.com/rob/32/8_2.png) [@rob](https://community.easyqlik.com/u/rob)
#### Post date: [April 19, 2021, 2:54am UTC](https://community.easyqlik.com/t/cant-find-bad-name-in-chart-suggestions/55/7 "2021-04-19T02:54:58Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![goliven](https://community.easyqlik.com/letter_avatar_proxy/v4/letter/g/5e9695/32.png) [@goliven](https://community.easyqlik.com/u/goliven)
#### Post date: [April 19, 2021, 3:03am UTC](https://community.easyqlik.com/t/cant-find-bad-name-in-chart-suggestions/55/8 "2021-04-19T03:03:30Z")

</div>

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”  
},
