Values from data file not updated upon reload

Fri, 15 Jan 2016 02:52:41 GMT

Scenario:

I have 6 expressions in a pivot table out of which 3 are inputfields. source for these inputfields are from an excel file. When values are updated in excel file, the same are not reflected upon data reload. Values loaded during first reload continues to display. However, upon trying to reload 3-4 times, new values at pulled during one of the attempts.

Data model sample script is as below:

Main table:

Load

%Key

Dim1,

Dim2,

Dim3,

Dim4,

Exp1,

Exp2,

Exp3

from source;

Excelsource:

Load

%Key,

Inputfield1,

Inputfield2,

Inputfield3

From excelfile;

Table:

Dim1, Dim2, Dim3, Exp1, Exp2, Exp3, Inputfield1,Inputfield2,Inputfield3

A B C 1 1 1 10 11 12

Lets say initially values pulled are 10,11,12 for above 3 inputfields. I edit excel file and change values to 5,6,7 instead. When i saved the file and reload my qvw, it continues to show 10,11,12 in my table instead of 5,6,7

When i try to reload 3-4 times , one of the times it clicks and updated values are pulled. I am not able to zero-in on the issue.

Can someone please tell me what can be the cause for this or if i am missing sometime?

Re: Values from data file not updated upon reload

tresB — Fri, 15 Jan 2016 05:22:48 GMT

Could you post a sample qvw and excel that shows the issue?

topic Re: Values from data file not updated upon reload in QlikView

Values from data file not updated upon reload

Re: Values from data file not updated upon reload