topic Re: How to use order by clause while loading data from qvd in QlikView

How to use order by clause while loading data from qvd

Mon, 26 Jan 2026 18:19:17 GMT

I m using this trick for order by.

Maintable:

LOAD

filed1,

filed2,

field3

from

FROM

netadd_from_mindate_to_tilldate.qvd(qvd);

temp:

NoConcatenate

Load * resident Maintable

order by field1, filed2 ;

drop table Maintable;

rename table temp to Maintable;

store Maintableinto 'D:\reruntesting\Data\RawQvds\Maintable.qvd';

But this is giving error like

"Field not found temp:"

Can anyone please tell what mistake i m doing?

Thanks

Peter_Cammaert — Mon, 17 Dec 2012 08:12:28 GMT

Please check the spelling in your example code. Field names don't match, and you have two FROM clauses in the first load.

Best,

Peter

sujeetsingh — Mon, 17 Dec 2012 08:43:53 GMT

I dont get why are you renaming the temp table is it too much needed

Mon, 17 Dec 2012 08:47:37 GMT

Thanks Peter,

i really ashamed on asking this type of stupid question. I should take care of these things.

It was typing mistake.

Mon, 17 Dec 2012 08:50:01 GMT

Yeah! you are right, actually its not required to rename.

er_mohit — Mon, 17 Dec 2012 08:51:49 GMT

check your spell i.e field1 or filed1 for this so, remove this error and might be helpful for you....