Tuesday, November 25, 2014

Problem: Drag and Drop Straight Table Columns Not Working

One of the other consultants at work came to me last week with a seemingly odd problem. She had a document with a straight table that originally had one dimension column. She added two more dimension columns and QlikView added the new columns on the right-hand side of the table. But, my co-worker wanted all three dimension columns to be on the left of the table which is the way we usually set up a straight table. Normally, dragging the new columns over to the left should be quick and easy… but, no matter how many times she tried, the new columns could not be dragged and stayed stubbornly on the right.

After close examination, some trial and error, and a bit of logical thinking; the source of the problem became clear. The thing that was interfering with the drag-and-drop of the dimension columns was the few columns in the chart that were not visible. In this case, there were two kinds: a hidden column, and three conditional columns that would only be visible under specific conditions.

The source of the problem suggested a solution:  right-click on the straight table, select Properties and choose the Presentation tab. One by one, click on each of the columns shown on the Presentation tab and make sure the Show Column radio button is selected for all columns (not Hidden or Conditional). Then, when all columns are visible, the drag-and-drop will work normally. After rearranging the columns as desired, use the chart Properties and Presentation tab again to restore the hidden columns and conditional columns.
One of the blog comments below suggests there is another type of non-visible column that would affect a Table Box: a column referring to a field no longer available in the document. You would have to edit properties for the Table Box and remove the field that no longer exists to restore drag-and-drop capability.


Anonymous said...

I would like to add some other cause for this that happens a lot during development. When you have a column for a field that is not in the data model anymore, the dragging gets completely messed up and won't operate normally until you delete this field from the column list in the properties.

Steve Dark said...

Hi Tim - thanks for this. I have often hit the problem with moving columns - and will be temporarily showing hidden columns next time it hits.

McNater said...

I agree, I've run into this before but could not pin point why it was happening. Makes sense now. Thanks!

Z He said...

Nice summary, had this problem before, and the hidden column also effect the column order in template in nprinting. And before checking the hidden column and Conditional, first of all, you need to check the "Allow Drag and Drop" option in Presentation tab.