Sort on multiple columns in straight table

[#1]

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...!!!

[sunilkumarqv]

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]

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]

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