topic Re: data Replacement in QlikView

data Replacement

Sat, 07 Jul 2012 10:32:27 GMT

i have devloped dashboard which contains data for visits of site monthly basis .

while loadig data for month may i have used wron data for category 'ABC'

so i need to correct it.

Now i am using where conditaion to remove may month data for 'ABC'.

but i found that data for 'ABC' removed when i used below condition

LOAD

qvd where category<>'ABC' and Month<>'May';

so i have to load all month data for ABC.

is there any way to remove data for only month May for ABC.

or there is any way to replace only that rows which contains wrong data because

it is a big application and even loding data into qvd for a month is also challenge.

Re: data Replacement

swuehl — Sat, 07 Jul 2012 11:05:03 GMT

Try

LOAD

qvd where not (category='ABC' and Month='May');

Re: data Replacement

Sat, 07 Jul 2012 11:50:33 GMT

Thanks,

but is there any way to replace the values which i want to change without loading all data after removing wrong data.

is there any way to replace value into qvd for any month and category.

Re: data Replacement

swuehl — Sat, 07 Jul 2012 11:57:50 GMT

I personally know of no way to directly change data in a qvd.

But, I don't see your point here really. You loaded wrong data at one point in time and stored this into a qvd.

So, why not load the correct data, append your historic data from qvd (without the wrong data, using where clause), then store the complete, correct data back in a qvd (i.e. replacing your existing qvd with the incorrect data).

You only need to do this once, so I see no reason in worrying about performance here.

Re: data Replacement

Sat, 07 Jul 2012 12:04:16 GMT

ok,

Thanks,