topic Re: How do I sort the actual columns - (not column data) in order? in QlikView

How do I sort the actual columns - (not column data) in order?

josephinetedesc — Tue, 20 Jun 2017 23:20:03 GMT

For example I have 3 columns - which must always appear in a certain order.

without changing the field name how would I do this?

for example:

column1:Id

column2:cost

column3: age

I need to always present any tables as: column1, column2, column3 - regardless of the contents of the columns.

Is there some way of doing this?

If I manually renamed

column1 - 1&' '& Id,

column2 - 2&' '& cost,

column3 - 3&' '& age,

How would I then organise the table to present the data with the original fieldnames/column names?

Thank you

Re: How do I sort the actual columns - (not column data) in order?

Sergey_Shuklin — Wed, 21 Jun 2017 04:43:35 GMT

Hello, Jo!

What do you mean by saying "column must always appear". As far as I know columns are "appear" manualy - when you create a table or using expression to indicate column you are making the order by hands.

Where they should appear in the right order? In the list of fields?

Re: How do I sort the actual columns - (not column data) in order?

josephinetedesc — Wed, 21 Jun 2017 06:27:42 GMT

woops!

I was looking at the wrong spot! I probably need to delete this post - Sorry Everybody!