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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting columns

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.

5 Replies
sathishkumar_go
Partner - Specialist
Partner - Specialist

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

Not applicable
Author

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

Not applicable
Author

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
Partner - Specialist
Partner - Specialist

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
Partner - Specialist
Partner - Specialist

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