Straight table with many conditional columns won't allow changes
I have a large straight table in Qlik Sense (on-prem May '24 Patch 5).
In the table I have many conditional columns, which will only display if a user selects a value from a field list in another table.
I'm not aware of a limit of how many columns can be created like this, but I have a problem with one of the dimensions now saying that the dimension doesn't exist. If I remove it, the table won't change or update. If I exit edit mode and come back to edit mode, the column is back and nothing has changed. I've closed my browser and even restarted my local machine, but the issue persists.
It's likely a metadata/caching issue or minor application corruption surrounding that table object, possibly triggered by the high number of conditional columns. Try duplicating my wisely the table object and deleting the old one, or if that fails
Hi, please try creating a new one. This issue is likely due to metadata caching or minor corruption related to that specific table object as @giwol42523 also mentioned. Starting fresh often resolves it.
Unfortunately there are many columns, and it took a long time to build them, and we can't afford the time to redo the table now. I did copy the table, and it had the same problem. I then started removing conditional columns one by one, and after removing about 10, the table worked again. We've decided, as a workaround for now, to remove less prioritised columns.
There were recently a posting about limits to the max. number of 1000 to expressions and dimensions of a table-chart. There may similar ones to further properties (labels, conditions, comments, ...) and there might be also dependencies between all them. Therefore you might have been hitting any threshold.
you can try below Do we have calculation in Error column. share calculation/ or correct your calculation it might happen, column name got changed if so, change with New one. Move Calculation to script.
In Qlik Sense, a straight table with many conditional columns can cause a bug where changes made in the edit mode are not saved or reflected. Users have reported that after deleting a column, exiting, and re-entering edit mode, the deleted column reappears.
