How to apply the changes made in data source to Qlikview Docs

[arixooo123]

My qlikview document has a Access Source, I like to add year attribute to the Table. also i must add the data of first quarter of 2014 to the table.

the question is how to apply these changes to QlikDoc?

Should i just reload? or there are other extra steps involved?

Thank you in advance

[VishalWaghole]

Once you completed your changes in Access Source,

then go to Edit Script of QlikView, and add the extra fields that you have inserted in specific table.

and click to reload, thats it............

-- Regards,

Vishal Waghole

[#3 · Accepted solution]

Hi arman,

From the Source table if u have your Date field Present then you required to create MasterCalendar with resident table from source table.In new table you can able to create your Date ,Year, Q1,Q2,Q3,Q4 field which helpful for your application further.

In Scirpt level you may follow below steps:

SourceTbl:

Load

otherFields,

DateField

SourceFolderpath;

Calendar:

Year(DateField) as Year,

LOAD

Date(DateField,  'MMM-YYYY') AS MonthYear,

Day(DateField) AS CalendarDayOfMonth,

WeekDay(DateField) AS CalendarDayName,

Week(DateField) AS CalendarWeek,

Month(DateField) AS CalendarMonth,

if(num(Month(DateField)) > 6 ,(Year(DateField) + 1),Year(DateField)) AS FIN_YEAR ,

if(num(month(DateField))>=1 and num(month(DateField))<=3,'Q4',

if(num(month(DateField))>=4 and num(month(DateField))<=6,'Q1',

if(num(month(DateField))>=7 and num(month(DateField))<=9,'Q2',

if(num(month(DateField))>=10 and num(month(DateField))<=12,'Q3')))) as FinancialQuarter

resident YourSourcetblName;