topic Re: Selecting only a few rows. in QlikView

Selecting only a few rows.

Mon, 17 Jun 2013 09:39:04 GMT

Hello,

I just started working with Qlikview for my company, and i'm extracting some data from the database to see which fields i actually need. is it possible to select only, let's say, 40 rows from a table? This is my code. I want to put it in a QVD file to do some tests. but I dont want to put all the data in there cause there's alot of data in our database and it will take a long time.

[Stock]:
LOAD
    PART1_PART               as [KeyPart], //Primary Key
    PARTSTD_SOURCE     as [Source],
    PARTQTY_STOCK        as [InStock],
    PARTMRP_STOCK       as [SubStock],
    PARTQTY_TRANS        as [InTransit],
    PARTQTY_QUAR         as [PartStockQuaraine],
    PARTQTY_1                 as [PartStockRemoteStores],
    date(today())                 as [Date]
;
SQL SELECT  
    PART1_CO_SITE,
    PART1_REC_TYPE,
    PART1_PART,
    PARTSTD_SOURCE,
    PARTQTY_STOCK,
    PARTMRP_STOCK,
    PARTQTY_TRANS,
    PARTQTY_QUAR,
    PARTQTY_1 
FROM PART_DATA
WHERE PART1_CO_SITE ='$(Company)' 
AND PART1_REC_TYPE=1;
STORE [Stock] INTO "DATA_NEW/Stock.QVD";

Re: Selecting only a few rows.

Mon, 17 Jun 2013 10:02:37 GMT

try in this format.

Load *

where MASTER_ID = 0;

SQL

SELECT *

FROM Persons;

*****************************************

Now in your script

$(Company) indicates the variable, so it must be define.

[Stock]: LOAD PART1_PART as [KeyPart], //Primary Key PARTSTD_SOURCE as [Source], PARTQTY_STOCK as [InStock], PARTMRP_STOCK as [SubStock], PARTQTY_TRANS as [InTransit], PARTQTY_QUAR as [PartStockQuaraine], PARTQTY_1 as [PartStockRemoteStores], date(today()) as [Date] ; SQL SELECT PART1_CO_SITE, PART1_REC_TYPE, PART1_PART, PARTSTD_SOURCE, PARTQTY_STOCK, PARTMRP_STOCK, PARTQTY_TRANS, PARTQTY_QUAR, PARTQTY_1 FROM PART_DATA WHERE PART1_CO_SITE ='$(Company)' AND PART1_REC_TYPE=1; STORE [Stock] INTO "DATA_NEW/Stock.QVD";

Re: Selecting only a few rows.

amars — Mon, 17 Jun 2013 10:14:43 GMT

Go to Edit Script -> Debug -> use limited Load with 40

Re: Selecting only a few rows.

Mon, 17 Jun 2013 10:18:27 GMT

I don't follow you, i'm sorry. I defined the variable.

I was searching, and in this possible?

SQL

First(40) SELECT

PART1_CO_SITE,

PART1_REC_TYPE,

PART1_PART,

PARTSTD_SOURCE,

PARTQTY_STOCK,

PARTMRP_STOCK,

PARTQTY_TRANS,

PARTQTY_QUAR,

PARTQTY_1

FROM PART_DATA

WHERE PART1_CO_SITE ='$(Company)'

AND PART1_REC_TYPE=1;

Re: Selecting only a few rows.

Mon, 17 Jun 2013 10:26:43 GMT

Thanks! That's what i was looking for.

Re: Selecting only a few rows.

Mon, 17 Jun 2013 11:55:32 GMT

Also one possible way is to use

Where ROWNUM < 40 //works at least in PL SQL