topic Re: rearranging fields in QlikView

rearranging fields

Anonymous — Wed, 21 Nov 2012 07:43:03 GMT

hi guyz,

i nid help.... i have a field say A_table

in A_table i have values 1_a, 2_b, 3_c wen i load d order is 1_a,2_b, 3_c

Now i want to load A_table with values in different order like 2_b, 1_a , 3_c

how to do?

Any help plz?

regards,

Vaibhav

Re: rearranging fields

Anonymous — Wed, 21 Nov 2012 07:49:23 GMT

You can create a separate field with the sort order and sort by expression.

For example:

Load * Inline [

F1, F2

a, 2

b, 1

c, 3

];

Sort field F1 by F2 and you will get b, a, c.

Or, you can combine them into one field using dual():

Dual(F1, F2) and then the field can be sorted numerically.

Re: rearranging fields

its_anandrjs — Wed, 21 Nov 2012 07:51:34 GMT

Hi,

Give ranking to your your fields like

1_a, 2

2_b, 1

3_c, 3

Regards,

Anand

Re: rearranging fields

Anonymous — Wed, 21 Nov 2012 07:56:24 GMT

hi jonannes,

thnx for the quick reply but m not able to do.

i have a table feild n m not using any inline....plz help

Re: rearranging fields

its_anandrjs — Wed, 21 Nov 2012 07:56:48 GMT

Hi,

Create another Load order table and add field Order with numbering 2,1,3 to field

loadOrder:

load * inline

[

A_table,Order

1_a, 2

2_b, 1

3_c, 3

];

and after that in the properties of the object in Sort tab -> in expression select =Order field and make sort by tis order

HTH

Regards,

Anand

Re: rearranging fields

Anonymous — Wed, 21 Nov 2012 07:57:08 GMT

hi anand,

How to do tat in script?

Re: rearranging fields

Anonymous — Wed, 21 Nov 2012 08:03:31 GMT

hi anand,

Everythng as to be in d script.

Re: rearranging fields

Anonymous — Wed, 21 Nov 2012 08:53:50 GMT

Any one can help plzzzzzzzzzzz