topic Re: How to apply the changes made in data source to Qlikview Docs in QlikView

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

arixooo123 — Sat, 05 Jul 2014 04:45:27 GMT

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

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

VishalWaghole — Sat, 05 Jul 2014 05:00:16 GMT

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

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

Sat, 05 Jul 2014 05:01:33 GMT

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;