topic Re: TOP N rows from QVD in QlikView

TOP N rows from QVD

chiru_thota — Tue, 04 Feb 2014 15:45:02 GMT

Hi All,

I need to get first 10 rows from a QVD into QVW irrespective of data.

Is there any way we can do that ?

Thanks,

Chiru

Clever_Anjos — Tue, 04 Feb 2014 15:48:39 GMT

FIRST 10

LOAD

FROM QVD.qvd(qvd)

luis_pimentel — Tue, 04 Feb 2014 15:48:51 GMT

Something like this should work:

FIRST 10

LOAD

FROM yourdata.qvd (qvd);

LOAD

FROM

yourdata.qvd (qvd)

WHERE

RowNo() <= 10;