topic Order By in QlikView

Order By

oliveira1903 — Mon, 02 May 2016 17:33:17 GMT

Hi guys,

I am new in Qlik. =]

I'm trying to use the order by but when I drop the table, everything is gone.

For example:

Table 1:

Load

Dado1,

Dado2

FROM

[.. \ .. \ Blabla\ QVD \ RH \ Tabela1.qvd] (QVD);

Table 2:

LOAD *

Resident Table1

Order By _______desc, _______ desc;

Drop Table Table 1;

I used this example (Can you use 'Order By' in a QVD Load?) but for me it didn´t work.

What am I doing wrong?

Thanks

Re: Order By

sunny_talwar — Mon, 02 May 2016 17:53:40 GMT

You need to add NoConcatenate in your resident load because you are loading all your fields from the previous table. QlikView auto concatenates them and when you drop your first table, everything is gone

Table 1:

Load

Dado1,

Dado2

FROM

[.. \ .. \ Blabla\ QVD \ RH \ Tabela1.qvd] (QVD);

Table 2:

NoConcatenate

LOAD *

Resident Table1

Order By _______desc, _______ desc;

Re: Order By

swuehl — Mon, 02 May 2016 17:54:08 GMT

You need to use a NOCONCATENATE LOAD Prefix:

Table 1:

Load

Dado1,

Dado2

FROM

[.. \ .. \ Blabla\ QVD \ RH \ Tabela1.qvd] (QVD);

Table 2:

NOCONCATENATE

LOAD *

Resident Table1

Order By _______desc, _______ desc;

Drop Table Table 1;