Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

how to load data into qvd in qliksense?

Hi all,

            when i am loading the data from excel file i can create qvd using STORE ASCII into [lib://qvd/ASCII.qvd] (qvd);

but when i am loading from data base i am not able to store the data into qvd? is therre any solution for this?

Regards,

Mike

9 Replies
Not applicable

Re: how to load data into qvd in qliksense?

Hi all,

The following error occurred:

Connection not found: SALES_DATA_SUMMARY.qvd

The error occurred here:

Store SALES_DATA_SUMMARY into [lib://SALES_DATA_SUMMARY.qvd] (qvd)

Regards,

Mike

balrajahlawat
Esteemed Contributor

Re: how to load data into qvd in qliksense?

reddys310
Honored Contributor II

Re: how to load data into qvd in qliksense?

Hi Mike,

The error which you are getting is because of the connection. Its not with the syntax. When the connection fails, no data is retrieved and hence "Store SALES_DATA_SUMMARY into [lib://SALES_DATA_SUMMARY.qvd] (qvd)" statement would through an error because the table SALES_DATA_SUMMARY does not exist.

i would suggest you to check your data connection and make sure your connection string is embedded before the load statement.

If you can post the code which you are trying to execute, it would be easier to solve the issue.

Best Regards,

Sangram Reddy.

Not applicable

Re: how to load data into qvd in qliksense?

hi Sangram Reddy,


This is the code

LIB CONNECT TO 'BUTAIMDBI02';

Sales_DATA_SUMMARY:

LOAD ID,

    CompanyID,

    CompanyName,

    CompanyType,

    State,

    City,

    Zip,

    sales,

SQL SELECT ID,

    CustomerID,

    CustomerName,

    CompanyType,

    State,

    City,

    Zip,

    sales

FROM StagingDB.dbo."Sales_DATA_SUMMARY";

Store INVOICE_DATA_SUMMARY into [lib://Documents/Qlik/qvd/Sales_sUMMARY.qvd](qvd);

Regards,

Mike

reddys310
Honored Contributor II

Re: how to load data into qvd in qliksense?

Hi Mike,

the load statement should end with  a semicolan.

Try this:

LIB CONNECT TO 'BUTAIMDBI02';

Sales_DATA_SUMMARY:

LOAD ID,

    CompanyID,

    CompanyName,

    CompanyType,

    State,

    City,

    Zip,

    sales ;

SQL SELECT ID,

    CustomerID,

    CustomerName,

    CompanyType,

    State,

    City,

    Zip,

    sales

FROM StagingDB.dbo."Sales_DATA_SUMMARY";

Store INVOICE_DATA_SUMMARY into [lib://Documents/Qlik/qvd/Sales_sUMMARY.qvd](qvd);

Not applicable

Re: how to load data into qvd in qliksense?

hi Sangram Reddy,



i checked with a semicoln also



but error is

---

Started loading data

Connecting to BUTAIMDBI02

Connected

Sales_DATA_SUMMARY << Sales_DATA_SUMMARY

Lines fetched: 97,106

The following error occurred:

Connection not found: qvd

The error occurred here:

Store Sales_DATA_SUMMARY into [lib://qvd/Sales_DATA_SUMMARY.qvd](qvd)

Data has not been loaded. Please correct the error and try loading again.

Regards,

Mike

Not applicable

Re: how to load data into qvd in qliksense?

hi all,

              I am not able to edit and create a folder to store the data into folder, please check the below screen shot.

Capture.PNG

any solution for this?

Regards,

Mike

reddys310
Honored Contributor II

Re: how to load data into qvd in qliksense?

Hi Mike,

Are you using QlikSense server, If so ask your administrator to give you access to do it. You need to have appropriate rights to do so.

reddys310
Honored Contributor II

Re: how to load data into qvd in qliksense?

Hi Mike,

Your script looks right to me. It could be the issue with the rights. I would suggest you to check with your server Admin if any rights are missing.

Community Browser