Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
sculptorlv
Creator III
Creator III

Change position for Dimension and expression

I have table with dimensions and expressions1.jpg:

I can move Dimension positions ... before Expression

and I can move Expression positions ...after Dimensions

How can I create similar Table with the SAME values, but another Column order. For example, I need to create table with the following columns:

Expr.1, Expr4., Dim.1, Expr.5, Dim2.

But the values must be the same.

1 Solution

Accepted Solutions
thakkarrahul01
Creator
Creator

Hi,

You have to click on dimension or expression header in straight table(a blue arrow will appear) now drag it to desired position and it will be done.

Kind regards,

Rahul Thakkar

View solution in original post

3 Replies
hareeshkumar_gv
Contributor III
Contributor III

Hi,

It is possible in straight table

thakkarrahul01
Creator
Creator

Hi,

You have to click on dimension or expression header in straight table(a blue arrow will appear) now drag it to desired position and it will be done.

Kind regards,

Rahul Thakkar

Not applicable

you can either drag the column to the order that you want or when you go into the expression and the dimension window, you can promote/demote the order of fields.  I am not sure if you can do anything regarding moving dimesions after expressions and vice-versa

one thing you can do is to use a dimesion as an expression.  Instead of including the field in the dimesion list, assign it as an expression iwth the '=' in fornt of the name - this will then include in the dimension side