topic Re: Change value in QVD file in QlikView

Change value in QVD file

Tue, 25 Feb 2014 14:24:30 GMT

Hi,

I have qvd file with lots of data.

Please see below first two rows have wrong Net Qty. now I want to set this Net Qty = 1

How can I change in QVD file only those values?

Re: Change value in QVD file

mvanlutterveld — Tue, 25 Feb 2014 14:28:50 GMT

Assuming that INVO is the unique ID for the records in your QVD, you can do the following while loading the QVD:

If(INVO = '08237034' or INVO = '08283911',1,NetQty) as NetQty.

After that store the QVD.

Cheers,

Michiel

Re: Change value in QVD file

Anonymous — Tue, 25 Feb 2014 14:29:28 GMT

Vinay

Write a quick qw to load the qvd, with an IF to mend your data, then store it into a qvd.

[Or use a 3rd party tool to edit the qvd, as long as your faith in the integrity of the tool]

Best Regards, Bill

Re: Change value in QVD file

alexandros17 — Tue, 25 Feb 2014 14:30:04 GMT

If The key for your qvd file is for example username then

Load

if(username = 'username_to_change_value', newval, oldval) as field_to_change

fld1,

fld2,

...

from qvd

Hope it helps

Re: Change value in QVD file

Clever_Anjos — Tue, 25 Feb 2014 14:34:48 GMT

You can´t change a QVD, only rewrite than

Create an empty aplication implementing a a IF logic to fix the value

Store the values to a new qvd

Re: Change value in QVD file

its_anandrjs — Tue, 25 Feb 2014 14:51:12 GMT

Hi,

On existing QVD you are not able to change those data but you are able to create another QVD without loading those data for '08237034' or '08283911' and create another QVD other wise on dashboard you are able to show 1 for those IDs.

HTH

Thanks & Regards

Re: Change value in QVD file

Tue, 25 Feb 2014 15:50:03 GMT

Thanks Michiel,

I have used if like ... and it working fine. thanks again.

accpg_accno,
accpg_opr,
accpg_ordtyp,
accpg_pno,
Branch,
[Branch Name],
DECDDT,
DECDDT1,
username,
usertype,
IVNO,
if((Branch = '127' And IVNO = '08283911') or (Branch = '123' And IVNO = '08237034') , 1, [Net Qty]) as [Net Qty],
[Net Sales]
FROM
(qvd);

Re: Change value in QVD file

Tue, 25 Feb 2014 19:25:12 GMT

Hi, I was also having many queries during the course of my learning, but found this informative tutorial http://www.youtube.com/watch?v=8olMt2AOUJ8 . Perfect tutorial for me, just right. Most certainly recommend this course to others.

Re: Change value in QVD file

Wed, 26 Feb 2014 10:45:00 GMT

Thanks. I will watch definitely.