Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to update a QVD file?

Hi Everyone,

Please help me regarding updating QVD file.

Potential:

LOAD Number

FROM

potential.xlsx

(ooxml, embedded labels, table is Sheet1)

where not exists(Number);

Concatenate

load Number from Potential.qvd(qvd)

where not Exists(Number);

store Potential into C:\Documents and Settings\sachin.GALAXYHO\Desktop\samples\Potential.qvd;

I have changed a value in Numer column ie i have updated value 1 to 11111 in number column in my excel file.
Now when i use above code then it gives me error"execution failed"

please tell me how do i update my QVD file?

Tags (3)
10 Replies
Not applicable

Re: How to update a QVD file?

File that you loading from and storing to might be not the same.

Not applicable

Re: How to update a QVD file?

Hi,

Pls change path C:\Documents and Settings\sachin GALAXYHO\Desktop\samples\Potential.qvd;

instead of

store Potential into C:\Documents and Settings\sachin.GALAXYHO\Desktop\samples\Potential.qvd;

Dont put " . " in folder name .

Hope it will help u

regards-bika

Not applicable

Re: How to update a QVD file?

Hi Bika,

It is not working,
It is a path which is directly coming after loading table from the potential excel file.

regards-hitesh

er_mohit
Honored Contributor II

Re: How to update a QVD file?

see the attached file

simply you try to change the path E:\ update.qvd;

then see the result where you wrong

sbobbyraj
Contributor III

Re: How to update a QVD file?

HI,

If you want to update your QVD, then you have to load it first.

In your example, the script will be:

Potential:

LOAD

      Number

FROM

     Potential.qvd(qvd)

;

LOAD

     Number

FROM

     potential.xlsx

(ooxml, embedded labels, table is Sheet1)

Where

     not exists (Number,Number);

store Potential into C:\Documents and Settings\sachin.GALAXYHO\Desktop\samples\Potential.qvd;

Not applicable

Re: How to update a QVD file?

Hi Mohit,

I am using personal edition so plz copy the code in word file and attach.

thanks and regards,

Hittesh.

Not applicable

Re: How to update a QVD file?

TRY ACCORDING TO THIS--

POTENTIAL_QVD:

LOAD * INLINE [

    id,name

    1, dddk

    2,cck

];

join

POTENTIAL_EXCEL:

LOAD * INLINE [

    id,name

    1, dk

    2,cck

    3,ab

    4,cd

]Where not Exists(id);

STORE   POTENTIAL_QVD into D:\POTENTIAL_QVD

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

or try this

POTENTIAL_QVD_test:

LOAD * INLINE [

    id_test,name_test

    1, dddk

    2,cck

];

Right Join

POTENTIAL_EXCEL_test:

LOAD * INLINE [

    id_test,name_test

    1, dk

    2,cck

    3,ab

    4,cd

];

STORE   POTENTIAL_QVD into D:\POTENTIAL_QVD

er_mohit
Honored Contributor II

Re: How to update a QVD file?

sorry for late reply

script is

a:

LOAD product_id ,

     p_value

FROM

(ooxml, embedded labels, table is Sheet1);

Concatenate (a)

LOAD product_id ,

     p_value

FROM

(ooxml, embedded labels, table is Sheet2)

Where not Exists (product_id);

STORE a into E:\Update.qvd;

Re: How to update a QVD file?

Hi,

     One reason could be, you dont have the right to write into file.

     Kindly look into the windows file security.

     Also try deleting the QVD and regenerate it with diff name.

Regards,

Kaushik Solanki

Community Browser