Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
kristof_j
Creator II
Creator II

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
michielvandegoo
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 II
Creator II
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 II
Creator II
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 II
Creator II
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

michielvandegoo
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 II
Creator II
Author

Can you give me an example?

I've never heard of FirstSortedValue().