This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I've created a straight table with several dimensions and expressions. Some of these dimensions and expressions are hidden.
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.
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
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
Have you tried moving the dimension under dimensions or under presentation >> columns instead of dragging the column?
Sorry only under dimensions
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.
Tried that but doesn't work
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!
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
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().
Can you post screen prints of your dimension properties and the result displayed by QlikView before and after adding a dimension?
Can you give me an example?
I've never heard of FirstSortedValue().