Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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