Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kristof_j
Creator III
Creator III

Changing position of column in straight table doesn't work

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

1 Solution

Accepted Solutions
Michiel_QV_Fan
Specialist
Specialist

Try this:

Go to Presentation, unhide all hidden columns.

Move the URL_beschrijving to the left.

Hide the columns again.

Reload  if necessary.

View solution in original post

31 Replies
stevietm
Creator
Creator

Hi Kristof,

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

Regards

Stevie

stevietm
Creator
Creator

Sorry only under dimensions

kristof_j
Creator III
Creator III
Author

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
Creator III
Creator III
Author

Tried that but doesn't work

IAMDV
Luminary Alumni
Luminary Alumni

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
Creator III
Creator III
Author

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
Luminary Alumni
Luminary Alumni


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
Specialist
Specialist

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

kristof_j
Creator III
Creator III
Author

Can you give me an example?

I've never heard of FirstSortedValue().