topic Order By doesn't work in QlikView

Order By doesn't work

robert99 — Mon, 15 Sep 2014 16:49:59 GMT

Hope someone can help me on this

I have set up incremental load

But this loads the records in a different order

I tried to rectify this (as I need to do a lastvalue)

So I tried to sort this by various order

None work. I have loaded the script below (Call_Num and FSR_Num are both numeric)

Thanks

left keep (SCCall)
LOAD

FSR_Call_Num as Call_Num,

FSR_Num,

etc
AutoNumber (TEXT (Upper (FSR_Ser_Num)) & '/' & TEXT (UPPER (FSR_Prod_Num))) as SerialandProdNo, if (ApplyMap ('RepCodeAdj',FSR_Call_Num,'Missing')='Missing',FSR_Rep_Code, ApplyMap ('RepCodeAdj',FSR_Call_Num,'Missing')) as RepCode,

AutoNumberHash128 ( FSR_Call_Num , FSR_Ser_Num , FSR_Prod_Num) as CallSerial, //new if( NUM( ApplyMap ('WARRENDMAPP',AutoNumber ( TEXT (Upper (FSR_Ser_Num)) & '/' & TEXT (UPPER (FSR_Prod_Num))) ,'NoCode')) >

NUM( ApplyMap ('Callindate', FSR_Call_Num ,'NoCode')) ,'YES','NO') AS CallInWarr

resident SCFSRTess
where not Match (FSR_Employ_Num, '039') and not match (FSR_Rep_Code,'09',9)
order by FSR_Call_Num ,FSR_Num //FSR_Last_Update

;

Re: Order By doesn't work

maxgro — Mon, 15 Sep 2014 22:29:54 GMT

I think you have to resident load your final table (SCCall ?) another time to order it

Re: Order By doesn't work

robert99 — Tue, 16 Sep 2014 06:52:48 GMT

Thanks Massimo

I will try when I get to work. I have tried order by a number of times. It works at times but often I have had to find another way of doing what I wanted to.

Its possible that left keep and order by conflicts.

Re: Order By doesn't work

robert99 — Sun, 21 Sep 2014 13:22:14 GMT

I eventually used

load

Call_Num,

firstsortvalue (distinct FSR_Call_Num , - FSR_Num) as LastFSRNum

resident TABLE GROUP BY Call_Num;

This worked and did not need to sort

But I think the answer above (Massimo's) was correct