topic Re: Date Formats in QlikView

Date Formats

Thu, 10 Sep 2015 07:39:52 GMT

Hi All,

I have a date field and need to fetch FiscalYear, FiscalQuarter, Month, Week# and Day# from it.

Example :

DateField : 14/4/2015

Output:

FiscalYear: 2015-2016

FiscalQuarter: Q1

Month : Apr

Week# : 15

Day# : 14

Regards,

Keerthi KS

gautik92 — Thu, 10 Sep 2015 07:44:13 GMT

you have a create a master calendar to achieve this

alexandros17 — Thu, 10 Sep 2015 07:45:15 GMT

DateField : 14/4/2015

Output:

FiscalYear: Year(DateField) & '-' & Year(DateField)+1

FiscalQuarter: If(Month(DateField)<4,'Q1',If(Month(DateField)<7,'Q2',If(Month(DateField)<10,'Q3','Q4')))

Month : Month(DateField, 'MMM')

Week# : Week(DateField)

Day# : Day(DateField)

MK_QSL — Thu, 10 Sep 2015 08:13:54 GMT

use below blog post...