topic Re: Re: Partial reload script return zero in QlikView

Partial reload script return zero

Mon, 26 Jan 2026 18:19:17 GMT

Hi All

I have below script , it return zero for PRICE_LIST field.

left join

(PRICE)

Load PART_NO_,

'USD '& LIST_PRICE as PRICE_LIST

Resident PRICE;

Take note :-

For testing , pls unzip the file to folder = C:\GE

Re: Partial reload script return zero

fernando_tonial — Thu, 19 Sep 2013 03:16:30 GMT

Hi,

You have to put before the LOAD Add OR Replace, to the partial reload works.

Best Regards

Tonial

Re: Partial reload script return zero

Thu, 19 Sep 2013 03:19:22 GMT

Hi Sir

Thank for spot my mistake. Bit I not understand what you mean can you write a bit more ?

Paul

Re: Re: Partial reload script return zero

fernando_tonial — Thu, 19 Sep 2013 03:35:17 GMT

Hi, you can try this.

You can't SUM a field with text.


load *, 'USD '& LIST_PRICE as PRICE_LIST from $(vQVDPath)BECKHOFF.qvd (qvd);



Concatenate 



load *, 'USD '& LIST_PRICE as PRICE_LIST from $(vQVDPath)HAKKO.qvd (qvd);



Concatenate 



load *, 'USD '& LIST_PRICE as PRICE_LIST from $(vQVDPath)MITSUBISHI.qvd (qvd);



Concatenate 



load *, 'USD '& LIST_PRICE as PRICE_LIST from $(vQVDPath)GE.qvd (qvd);

Best Regards.

Tonial.

Re: Partial reload script return zero

Thu, 19 Sep 2013 04:56:08 GMT

Hi Sir

Thank you very much , your offer help me a lot .

Now i manage to make partial reload working fine.

And i can move on to get all other value cal out.

Paul