topic Re: sub sort in QlikView

sub sort

adiarnon — Mon, 30 Jun 2014 08:28:51 GMT

hi,

i have this table im my scheme-

project	level	sort2
a	1	8
b	1	1
c	1	3
d	2	4
e	2	3

i have a straight with project column.

i want that this column will be sort first by-project level ans second (subsort) by sort2.

how can i do that?

Re: sub sort

Mon, 30 Jun 2014 08:38:22 GMT

Hi Adi,

Right click on the table, go to properties. Then go to sort and change the sort order as required. The graph will be sorted as the order in which these appear. Move them up or down as required.

Regards,
Marius

Re: sub sort

adiarnon — Mon, 30 Jun 2014 08:48:24 GMT

i know how to sort.

but i need sub sort, i mean i want to sort the same column by two expression...

can i do that?

Re: sub sort

maxgro — Mon, 30 Jun 2014 08:58:02 GMT

first double click on sort2 label

then double click on level label

you get

Re: sub sort

maxgro — Mon, 30 Jun 2014 08:59:15 GMT

or (non interactive)

Re: sub sort

adiarnon — Mon, 30 Jun 2014 09:07:35 GMT

tnx,

but it was just an example in my real data i have text sort...

Re: sub sort

maxgro — Mon, 30 Jun 2014 09:25:04 GMT

post some real data

or did you try with Marius Koekemoer suggestion? you can set priority, choose sort by and then remove interactive sort