I work in Personal Edition. The QVW file may not work. I will share the script block.
LOAD * INLINE [
ACCESS, USERID, PASSWORD,CLIENTID
ADMIN, USER1, PWD1, 14
ClientID as CLIENTID,
Load * from VWBigPicture.QVD (qvd);
NoConcatenate LOAD *
order by ShipDate ASC;
Drop table ANLShipmentsTemp;
Here, I want the data to be sorted by shipdate, hence the temp loading. What is needed is only rows with clientid 14 should be shown to the user1. That is not happening!!