topic Re: Change position for Dimension and expression in QlikView

Change position for Dimension and expression

sculptorlv — Tue, 22 Dec 2015 13:56:52 GMT

I have table with dimensions and expressions:

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.

Re: Change position for Dimension and expression

hareeshkumar_gv — Tue, 22 Dec 2015 14:01:55 GMT

Hi,

It is possible in straight table

Re: Change position for Dimension and expression

thakkarrahul01 — Tue, 22 Dec 2015 14:08:01 GMT

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

Re: Change position for Dimension and expression

Tue, 22 Dec 2015 14:24:23 GMT

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