Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Lauri
Specialist
Specialist

Mysterious behavior - nonexistent field name in filter bar

We're on QS Enterprise Nov 2025 patch 2. We have an app that has a field named "Site" and a master dimension also named "Site". We experienced some odd behavior: When I selected a value from Site, the filter bar showed "SITE" (all caps). There is absolutely no field or dimension with that name or title. Why did it do this?

The app also caused trouble with an NPrinting report -- it would fail with a filter error: "False to current document data" that was supposed to filter based on Site. It failed for 3 of 5 values and succeeded for the other 2.

I got everything working normally (in Sense and NPrinting) by reloading the data with the field renamed (Load Site as "Site Name") and then reverting back to "Site" so it seems that the table in the database was somehow corrupt.

I've never seen anything like this. Wondering if it's a new problem. Maybe I'll never see it again.

Labels (1)
6 Replies
Or
MVP
MVP

Is the master item's Title (not name) ='SITE'? This is what shows up in the selection bar. 

Lauri
Specialist
Specialist
Author

The master dimension Name is "Site" and the Label expression is empty.

WeLoveQlik
Partner - Creator
Partner - Creator

was the data loaded via a SQL select statement?

IPC Global: ipc-global.com
Lauri
Specialist
Specialist
Author

No not with a SQL statement. The data all came from CSVs and Excel files.

marcus_sommer

Renaming a single field within the load - forward and backward - doesn't change mandatory the field because the field-index could keep the same and just the label for the field needs to be adjusted.

Therefore you may try to repeat the measurement by adding anything like: 'Dummy' as MyDummy before Site is loaded and/or dropping this field + saving the app and then reloading to enforce a change to the field-index.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

FWIW I had a similar problem recently on May 2025 patch 6.  There was a field selection ( with a legitimate name) showing in the selection bar. But there was no actual selection in that field. I couldn't clear this phantom selection chip. I also "fixed" the problem by reloading the field with a different name and then swapped back. 

Anyone else seen this?

-Rob