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

[stevietm]

Hi Kristof,

Have you tried moving the dimension under dimensions or under presentation >> columns instead of dragging the column?

Regards

Stevie

[stevietm]

Sorry only under dimensions

[kristof_j]

The funny thing is that the dimension isn't set as last.

Even if I put it at the top, it stays at the end.

[kristof_j]

Tried that but doesn't work

[IAMDV]

Hi,

For this situation, please use FirstSortedValue() in expressions for column sorting. Use most granular field (AKA: Primary key) as the dimension and rest all of them as expressions.

Let me check if I have a sample App but this definitely works!

Cheers,

DV

[kristof_j]

I don't understand what you mean.

It is not the sorting of the values of the columns but the position of each column.

I want to order the column as A, B, C but I keep getting A, C, B

[IAMDV]

Hi Kristof,

I'm talking about the same thing. I'm not talking about the Row sorting. I'm talking about Column position sorting. This can be done by using FirstSortedValue().

Thanks,

DV

[Michiel_QV_Fan]

Can you post screen prints of your dimension properties and the result displayed by QlikView before and after adding a dimension?

[kristof_j]

Can you give me an example?

I've never heard of FirstSortedValue().