9 Replies Latest reply: Feb 8, 2016 12:44 PM by Sangram Reddy RSS

    Qliksense: Load Data Into QVD

    ASma Erum

      I am currently using the Qliksense platform and not Qliksense Desktop.

      I am new to this tool and attempting to load date from our MSSQL database to QVD, however I do not understand why I cannot store it into a Directory or Lib? What is the Lib path. There seems to be a lack of documentation and I cannot seem to find a way to load this data.

      Also what would be the best approach. Would I have one app just dedicated to loading all data? i.E if I wanted to perform data refresh nightly?

       

      Here is my current script:

       

      DailyInventory:

      LOAD

      InventoryKey,

      OwnedQty,

      Warehouse,

      WarehouseKey,

      Date;

       

       

      SQL SELECT

      InventoryKey,

      OwnedQty,

      Warehouse,

      WarehouseKey,

      Date

       

       

      FROM RentalworksDW.dbo.DailyInventoryStatus;

       

       

      STORE DailyInventory INTO [lib://QlikSenseQVDFiles\DailyInventory.qvd](QVD);

       

      What is this lib:\\path?

      I tried C:\QlikSenseQVDFiles\DailyInventory.qvd](QVD) that did not seem to work either.