Discussion Board for collaboration related to Creating Analytics for QlikView.
Please explain in detail.
hiiii. , DATE is my field like this 28-9-2008 to 21-9-2012.
you can try this in script here
1stly you load your table then do this.
day(DATE) AS Day,
yeARNAME(DATE,0,2) as FinancialYear,
'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