Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

retracted

retracted

2 Replies
nirav_bhimani
Contributor III

Re: Please help with creating "quarter" and "annual" loads

Hi,

Please explain in detail.

Regards,

Nirav Bhimani

er_mohit
Honored Contributor II

Re: Please help with creating "quarter" and "annual" loads

hiiii. , DATE is my field like this 28-9-2008 to 21-9-2012.

so,

you can try this in script here

1stly you load your table then do this.

load *,

separate day:

day(DATE) AS Day,

separate month:

Month(DATE)AS Month,

for finanacial:

yeARNAME(DATE,0,2) as FinancialYear,

for quarter:

'Q' & Ceil(Month(DATE)/3) as Quarter,

          Dual(Year(DATE) & '-Q' & Ceil(Month(DATE)/3), Year(DATE) & Ceil(Month(DATE)/3)) as YearQtr,

for annual load :

year(DATE) as Year;

hope it helps you

Community Browser