Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

retracted

retracted

2 Replies
nirav_bhimani
Partner - Specialist
Partner - Specialist

Hi,

Please explain in detail.

Regards,

Nirav Bhimani

er_mohit
Master II
Master II

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