topic Re: Sort on multiple columns in straight table in QlikView

Sort on multiple columns in straight table

Mon, 10 Mar 2014 12:28:28 GMT

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

Re: Sort on multiple columns in straight table

tresB — Mon, 10 Mar 2014 12:35:23 GMT

In the sort tab, same thing happens and you can promote/demote the column to set priority.

Re: Sort on multiple columns in straight table

Anonymous — Mon, 10 Mar 2014 12:47:20 GMT

Hi Priya,

The sorting of multiple column in qlikview is possible . In straight table in sort tab here is the option of sorting . Here you can sort the expression and dimension both as of requirement.

Thanks

Re: Sort on multiple columns in straight table

maxgro — Mon, 10 Mar 2014 12:47:32 GMT

if you want to sort for expression A and then for expression B

first double click (more click for asc / desc) on label of B

second double click on label of A

not very intuitive but it works

hopre to understand your question

Re: Sort on multiple columns in straight table

Mon, 10 Mar 2014 12:48:29 GMT

But the interactive sort option is also provided. Thing is they want to make the dynamic groups based on column selections. As it is possible in Excel.

Re: Sort on multiple columns in straight table

tresB — Mon, 10 Mar 2014 12:54:57 GMT

That is not directly possibly here, if not at all not possible.

Re: Sort on multiple columns in straight table

Mon, 10 Mar 2014 13:15:01 GMT

If I first click on A column heading den it will sort by that column after that if user selects on column B then it sorts according to column B and the sort on column A goes off.

Requirement is if user clicks on column A first and then on B then it should first sort by A and then by B.

Re: Sort on multiple columns in straight table

maxgro — Mon, 10 Mar 2014 13:29:38 GMT

In Qlik it works in a different way: to sort by multiple fields, you have to work in reverse order

Re: Sort on multiple columns in straight table

Mon, 10 Mar 2014 13:36:06 GMT

Can u please elaborate ur point. I didn't get it.

Re: Sort on multiple columns in straight table

maxgro — Mon, 10 Mar 2014 13:45:23 GMT

see my previous answer or this

Dynamic sorting in Straight table chart

Re: Sort on multiple columns in straight table

sunilkumarqv — Mon, 10 Mar 2014 13:47:51 GMT

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!

Re: Sort on multiple columns in straight table

linoyel — Wed, 20 Aug 2014 11:48:31 GMT

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

Re: Sort on multiple columns in straight table

Anonymous — Mon, 21 May 2018 08:19:03 GMT

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