Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Partial reload script return zero

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

1 Solution

Accepted Solutions
fernando_tonial
Valued Contributor

Re: Re: Partial reload script return zero

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.

4 Replies
Highlighted
fernando_tonial
Valued Contributor

Re: Partial reload script return zero

Hi,

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

Best Regards

Tonial

Not applicable

Re: Partial reload script return zero

Hi Sir

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

Paul

fernando_tonial
Valued Contributor

Re: Re: Partial reload script return zero

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.

Not applicable

Re: Partial reload script return zero

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

Community Browser