topic Sorting columns in QlikView

Sorting columns

Thu, 21 May 2009 18:15:03 GMT

Hello,

Let's say I have 6 columns; A, B, C, D, E and F. With standard sorting they will be sorted as ABCDEF. How can I sort them like DBCAFE for instance?

Your help is much apreciated.

Kind regards.

sathishkumar_go — Thu, 21 May 2009 18:42:55 GMT

HI use inline

columns Seq

A 4

B 2

C 3

D 1

E 6

F 5

AND Chart properties -> Sor->Expression

IN eXPESSION U GIVE =Seq

I hope it ll help for u

Thanks

Sathish

Thu, 21 May 2009 19:30:01 GMT

If you go into the sort tab of your graph or table , you can change the priority of sorting by demoting or promoting fields.

Thu, 21 May 2009 20:36:14 GMT

Hi,

Inline is used in the main script right? I would like to know how I can achieve the same within a pivot table/ table.

I know I can change the sorting strategy in the preferences of the table, but that is not what I want.

Hope you can help. Thank you.

sathishkumar_go — Thu, 21 May 2009 20:44:19 GMT

hey sorting State, Expression,Frequency,Numeric Value, Text and Load Order

In ur case select load order or fefault A,B,C,D,E,F ll come

better u write inline otherwise u attach ur application then only i know anyother option is there or not?

sathishkumar_go — Thu, 21 May 2009 20:45:53 GMT

Hi attach ur application then only i know it is possible or not?