Changing position of column in straight table doesn't work

[kristof_j]

Hi

Situation

I've created a straight table with several dimensions and expressions. Some of these dimensions and expressions are hidden.

Problem

When I added a new dimension, QV puts the dimension at the end of the table. Every time I want to drag and the the column to change the position, the column stays at the end of the table.

My 'solution'

The only solution is that I recreate the table with al the expressions (+10 expressions) but after a few days the problem is back when I add a dimension

Or I create a expressions that contains only the new dimension and I hide the dimension and put that expression at the top.

Is this a common problem and can it be resolved?

Or did I do something wrong?

It happened in a few other dashboards too.

thx in advance

[IAMDV]

Interesting! I've never tried that but I'm keen to know if this solves this issue.

Kristof - Please can you try this before I work on mocking up an example for you?

Cheers,

DV

[kristof_j]

Lovely!

A simple solution.

Thanks Michiel and Deepak

[IAMDV]

Nice one Michiel.

Kristof - We can still give control to users to shuffle the column order and save a bookmark for customized views. I shall make a blog post on this very soon. Hopefully this might help you.

Cheers,

DV

[kristof_j]

I shall keep an eye on your blog

Added it to my feeds

[mgavidia]

Great tip!

I faced the same problem. I was going crazy trying to figure out why the columns did not relocate.

Thank you.

Miguel Gavidia

Los Angeles, CA.

[pgdavis2]

Any resolution?  Same problem here.  When I add a new dim to a straight table (5th dimension) it gets added after the expressions.

[kristof_j]

Paul

You probably have some columns that are hidden.

You need to unhide them and then you can reposition the dimension to the right position.

Afterward you can hide your columns again.

[pgdavis2]

Yes that was it!  Thanks

[#10]

Hi Michiel van de Goor,

I had the same problem as written here and I could solved the problem by your method!!

Thank you and this communications!

Woollymaster

Tokyo Japan

[Michiel_QV_Fan]