Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create and Load Fiscal Year from multiple files ? (Urgent!!)

Hi, I followed this tuto http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year but this script load only Fiscal yearS of the first (*.xslx) file. (CanonicalDate, FileName, *, *, *  are loaded from all files)

I posted this problem last month.

Can you help me please?

Set vFM = 10 ;

Load 

Dual(fYear-1 &'/'& fYear, fYear) as FYear, // Dual Fiscal year 

Dual(Month, fMonth)              as FMonth, // Dual Fiscal month

    *;

Load 

Year + If(Month>=$(vFM), 1, 0) as fYear, // Numeric Fiscal year 

Mod(Month-$(vFM), 12)+1        as fMonth, // Numeric Fiscal month

    *;

load

Month(CanonicalDate) as Month,

Year(CanonicalDate) as Year,

   *;

Load          // Your standard master calendar      

FileName() as FileName,

   *,

[Date 1er contact] as CanonicalDate,

'1er contact' as DateType,

   *,

   *,

   *,

   FROM C:\Prosp\*.xlsx (ooxml, embedded labels);

// I separated the loading dates to put all in CanonicalDate

Load [Date Action 1] as CanonicalDate,

'Action 1' as DateType

FROM C:\Prosp\*.xlsx (ooxml, embedded labels);

Load

[Date Action 2] as CanonicalDate,

'Action 2' as DateType

FROM C:\Prosp\*.xlsx (ooxml, embedded labels);

Load

[Date Action 3] as CanonicalDate,

'Action 3' as DateType

FROM C:\Prosp\*.xlsx (ooxml, embedded labels);

Load

[Date Action 4] as CanonicalDate,

'Action 4' as DateType

FROM C:\Prosp\*.xlsx (ooxml, embedded labels);

0 Replies