topic Re: Old data getting reloaded in QlikView

Old data getting reloaded

Tue, 27 Oct 2015 11:53:58 GMT

Hello everybody,

I have a QV file where i load the data from a few QVDs,

I just noticed that in my LOAD script on the main file (GUI) one of the fields I load (from one of the QVDs) is commented out,

even though I can still see that field in my tables... (I have a table with =sum(the_field_im_talking_about) and it still shows data...)

Could this make sense?

Re: Old data getting reloaded

Tue, 27 Oct 2015 15:47:49 GMT

Shahar,

Add this statement at the end of the script in your GUI file/qvw.

DROP FIELD your_field_name FROM your_table_name;

which will drop the the field from your GUI.

There might be a reason why you are seeing the loaded field even if you arent loading it in your qvd refresh. if your base load script loads the field & refreshed qvd's aren't loading it your qvw will have that attribute with historic data. so dropping it will fix the issue.

Thanks

Brad.

Re: Old data getting reloaded

Wed, 28 Oct 2015 08:15:06 GMT

Thanks!

I am new to QV and this project has been passed on to me,

seems like catching up would take a while...