Relecting spreadsheet changes

[#1]

Hi I am very new to QlikView, but we all have to start somewhere!

I have loaded a spreadsheet and have created some basic graphs. my problem is that when I change the data in the spreadsheet (add in a column) the changes don't appear in QlikView

I have tried RELOAD and it runs through the records but nothing updates.

I am sure this is a simple issue!

Baz

[mphekin12]

Can you post your .qvw file or at least show some screenshots of the Excel data and QV script?

[Anonymous]

Have you added the new column into the load script?

[#4]

‌As I said 'new user'

i have no load script. I have clicked on New File from the welcome screen, follow the instructions and go my data intp Qlikvie.

How and where should I put a load script

sorry this is so basic!

baz

[mphekin12]

If you used the wizard the script was written out for you automatically.  If you click the icon that looks like a sheet of paper with a pencil on it (it will say Edit Script if you hover over it) it will show you the script that was generated for you.  If you get a screen shot of that script along with a screen shot of the Excel file showing all columns that you want imported it would be a great help.

[Anonymous]

Being new user is not a crime

You do have load script.  It looks something like

LOAD

Field1,

Field2,

Field3

FROM ...;

Adding new column to excel file doesn't change the script.  You have to modify it manually, to something like

LOAD

Field1,

Field2,

Field3,

NewField

FROM ...;

[datanibbler]

... and the other alternative (which does have some advantages, but also some drawbacks)

If you go like

Table1:

LOAD

     *

FROM

...

=> that * means "all" - so this will simply load all fields that are there. It will adapt if any columns are added.

<=> I personally think this should be avoided because it can lead to unexpected results when you pass an app with a LOAD like this to other users, you never know exactly what might happen - and also because it's hard for someone else doing your job in your absence to understand just what fields are being loaded.

=> Whenever possible, you should write down the fields to load (just as the wizard will do for you, but will not do it again without your interaction if some column is added)

HTH

[#8]

OK great got it now.

understand and I have modified the script to bring in the new fields

thank you all  for your support ~ very good

I am sure I will be back to pester you soon

baz