topic Custom Sort at script level in QlikView

Custom Sort at script level

Tue, 19 May 2015 07:04:34 GMT

Dear All,

As qlikview loads the data bydefault in chronological order at script level, How can i change it to the load oder.

Because of this sorting , i am not able to get the exact data while applying concat function on 2 fields.

Ex: Source,Destination

A, C

D, F

Z, Q

As per my requirement it should give : Z-F/D-C/A-Q

But after concat it is giving : A-Q/D-C/Z-F

I have used the following formulae: concat((Source&'-'&Destination),'/')

Thanks in advance

Anonymous — Tue, 19 May 2015 07:17:20 GMT

One can sort with the order by clause of a resident load :

load

Source,

Destination

resident YourTable

order by Source, Destination ;

anbu1984 — Tue, 19 May 2015 07:37:24 GMT

Load *,RowNo() As RowNo Inline [
Source,Destination
A, C
D, F
Z, Q ];

=concat((Source&'-'&Destination),'/',-RowNo)