topic Re: financial year in QlikView

financial year

Wed, 11 Mar 2015 07:28:58 GMT

please help me

my fiscal year is from 01.03. - 28.02.

in my table i have a coluimn with year and a column wit period 1 to 12

Can u explain me what i have to do to get for Period 1 the month march for period 2 month April

im able to make the date from These two files like period 1 Year 2014 = 01.01.2014 with makedate but i Need 01.03.2014

thanx

Re: financial year

agni_gold — Wed, 11 Mar 2015 07:38:01 GMT

Date(MakeDate(2014,3,1),'DD-MM-YYYY')

Re: financial year

agni_gold — Wed, 11 Mar 2015 07:40:15 GMT

Date(MakeDate(2014,A+2,1),'DD-MM-YYYY')

Here A is my period

Re: financial year

PrashantSangle — Wed, 11 Mar 2015 07:47:05 GMT

Hi,

If you are able to create date field using makedate()

then for creating financial Year you need use

YearName(datefield,0,3)

Regards

Re: financial year

Colin-Albert — Wed, 11 Mar 2015 07:56:35 GMT

Try this

Addmonths(makedate(financial_year, 2), period)

Re: financial year

jagan — Wed, 11 Mar 2015 07:58:56 GMT

Hi,

Check this link for Fiscal Calendar generation

Fiscal and Standard Calendar generation

Regards,

Jagan.

Re: financial year

Wed, 11 Mar 2015 08:32:15 GMT

this is my script

Load Periode,

geschäfstjahr,

makedate(geschäfstjahr,Periode+2,1) as Date1,

YearName(Date1,0,3),

KST,

Wert

From....qvd

error

concatenate

field not found <Date1>

Re: financial year

jagan — Wed, 11 Mar 2015 08:34:38 GMT

Hi,

Try like this

LOAD

YearName(Date1,0,3) AS Year;,

Load Periode,

geschäfstjahr,

makedate(geschäfstjahr,Periode+2,1) as Date1,

KST,

Wert

From....qvd

Regards,

Jagan.

Re: financial year

Wed, 11 Mar 2015 08:37:18 GMT

thanx a lot

Re: financial year

Colin-Albert — Wed, 11 Mar 2015 08:40:13 GMT

Load Periode,

geschäfstjahr,

addmonths(makedate(geschäfstjahr,2), Periode) as Date1,

YearName(Date1,0,3),

KST,

Wert

From ... Qvd