Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort on multiple columns in straight table

Hi,

Is it possible to sort on multiple columns in straight table??

I have 1 Ad-hoc report in which there are multiple columns. In Excel there is one functionality that user can sort on multiple columns. I have attached the screen shot for the same excel functionality.

Is it possible to provide same functionality in QlikView??

Thanks in Advance...!!!

12 Replies
sunilkumarqv
Specialist II
Specialist II

If you want to sort dynamically first create a table of reqiurd field then resident it

Example

_Dimesion

Load * inline

[

Age,Name

25,A

30,B

40,C

];

use these filed in your chart let take an assumtion that Age As Dismesion and some experssions

If you want to make this sort order the default sort order for a field, you can also add it to the sort tab of your document properties (via Settings -> Document properties or via Ctrl + Alt + D).

Using this function we can define the following expression: In sort Tab properties

=match([NameLine], ‘A’, ‘B’, ‘C’)

Hope This helps!

linoyel
Specialist
Specialist

Hey Tresesco,

I'm trying to sort just by one expression, so I've promoted it to the highest priority,

but when I open the document the sort order returns to the original one.

Why?...

Anonymous
Not applicable
Author

Why don't you try combining the Age and the Date in a new column then sort by ascending. If you then make it a hidden column it should solve your issue

I suspect this would only work on numeric sorting

=Age&Date