topic Re: My load script work fine , after move to partial reload script it not working ? in QlikView

My load script work fine , after move to partial reload script it not working ?

paulyeo11 — Sat, 12 Oct 2019 13:51:02 GMT

Hi All

Why my below partial reload script now work ?

TABLE_P:

left keep (GL_TABLE)

load [Reporting Code],

if([AccountCode]>=5000000 and [AccountCode]<=5999999,'P_Revenue') as [P_Revenue_]

resident GL_TABLE;

When i move to GL Table load script , it work fine :-

Concatenate
LOAD
'PMC' as SOURCE,
[Account Code] as GL_CODE,
[Account Code] as AccountCode,

If([Account Code]>=5000000 and [Account Code]<=5999999,'P_Revenue') as [P_Revenue],

Paul Yeo

Re: My load script work fine , after move to partial reload script it not working ?

paulyeo11 — Sat, 12 Oct 2019 13:52:08 GMT

My QVW

Re: My load script work fine , after move to partial reload script it not working ?

dplr-rn — Sat, 12 Oct 2019 15:04:23 GMT

whats the error ?

Re: My load script work fine , after move to partial reload script it not working ?

paulyeo11 — Sat, 12 Oct 2019 21:11:23 GMT

Hi Sir

Thank you for your asking.

I have create 2 field , one of the field is from GL Table , Anther field is create from Partial load script.

When reload I don’t get any error.

When I use the 2 field to generate the report . The field that generate using partial reload does not give the correct vakue in Table . Where the field created from GL Table give the correct table value in table.

I have QVW file , there are 2 button , one is show the correct sales value , another button when click does not show the correct value in table.

Paul

Re: My load script work fine , after move to partial reload script it not working ?

paulyeo11 — Sat, 12 Oct 2019 21:35:56 GMT

Hi All

Below is my QVW

paul