topic Re: Sort data in a cell in QlikView

Sort data in a cell

sbfernandes — Mon, 18 Mar 2019 11:22:04 GMT

Greetings! Is there any way to sort data in a cell (alphabetically). Eg: (attached pic) Contents of Col B is to be sorted individually.

Re: Sort data in a cell

mrybalko — Mon, 18 Mar 2019 12:14:55 GMT

Hello @sbfernandes

Do you need new column on data loading stage or just chart expression?

Re: Sort data in a cell

sbfernandes — Tue, 19 Mar 2019 05:11:37 GMT

Hi Mrybalko

I require a new column in the loading stage.

Thanks.

Re: Sort data in a cell

mrybalko — Tue, 19 Mar 2019 13:04:56 GMT

Data:
LOAD
	RowNo() as RowID,
	Unsorted
Inline [
Unsorted
'zebra,lion,tiger'
'oil,apple,butter'
];

tmp:
LOAD
	RowID,
	SubField(Unsorted, ',') as Values
Resident Data;

LEFT JOIN('Data')
LOAD
	RowID,
	Concat(Values, ',') as Sorted
Resident tmp
Group by RowID
Order by Values;

drop Table tmp;

Re: Sort data in a cell

sbfernandes — Wed, 20 Mar 2019 03:58:21 GMT

Hi Mrybalko,
Many thanks for this. Works perfectly.