Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

hi

alreadyi loaded yesterday one table means i ve columns like this      region,branch,item,main type,sub type,model,design like this i ve in excel formatt and today i added one column ---> year in excel.. if i want load this YEAR column to Qlikview script

what i have to do

Thanks in advance

chandra

4 Replies
Highlighted
Specialist III
Specialist III

Re: hi

You can just concatenate the excel file having YEAR field.

Highlighted
Master III
Master III

Re: hi

hi

load year field and reload the script.

Highlighted
Not applicable

Re: hi

Hey,

If you are loading something like:

YourTable:

Load

    *

From [YourExcelFile];

You shouldn't have any problem with adding the YEAR field, by reloading you will automatically add the YEAR field.

If you are loading like:

YourTable:

Load

    YourField1,

    YourField2,

    ...

    YourFieldn

    ,YEAR

From [YourExcelFile];

Add what is written in Italic, the column YEAR, in your selected rows, and reload the document.

Highlighted
Not applicable

Re: hi

hi to all,

      Thanks for giving valuable suggestions,may be lonut explenation is good i ll follow this.