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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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?