topic Re: Sorting data in qlikview in QlikView

Sorting data in qlikview

sujit_nath — Tue, 25 Sep 2018 05:11:56 GMT

Hi Guys,

I have requirement as such:

The original column has values like:

I want to sort this and get the final output as:

Whats the way to do this and efficiently , as actual data is much bigger.

tresB — Tue, 25 Sep 2018 05:37:48 GMT

try like:

Load

FieldA,

'['&Concat(Num, '][', Num)&']' as Num

Group By FieldA ;

Load *,

Purgechar(SubField(FieldA, ']['),'][') as Num

Inline "

FieldA

[33][453][233][78]

[90][34][12]

[10][11]

[444][43][900]"

marcus_sommer — Tue, 25 Sep 2018 05:40:18 GMT

You could use something like this:

t0: load keepchar(subfield(FieldA, ']['), '0123456789') as FieldA from Source;

t1: noconcatenate load '[' & concat(FieldA, '][', FieldA) ']' as FieldA resident t0;

drop tables t0;

- Marcus

sujit_nath — Tue, 25 Sep 2018 10:13:59 GMT

Thanks Marcus and Tresesco. Let me try these and get back.