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.
$(Company) indicates the variable, so it must be define.
[Stock]: LOAD PART1_PART as [KeyPart], //PrimaryKey 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] ;
SQLSELECT 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;