Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

creating field for fiscial year between dates- qlik sense script

Hi,

I would like to :

We have a createdon date.Now,

create a string field i.e. fiscalyear in the load statement

create start and end date based on hard code dates.

use conditional statement , if createddate lies between the start and end date then assign the fiscialyear field to some string value..


e.g.


LOAD

date(2011-04-01, "YYYY-MM-DD") As datestarst;

date(2012-03-31, "YYYY-MM-DD") As dateends;

Fiscalyear  As fy_year

LOAD *inline [

Fiscalyear

FY11

FY12

FY13

FY14

FY15

];

LOAD CreatedOn as CampaignCreatedOn,

If (CampaignCreatedOn) >= (datestarst)

&

If(CampaignCreatedOn) <= (datestarst)

fy_year = "FY11"




wondered if its possible or ??


thx-Irf

Tags (1)
1 Reply
MVP
MVP

Re: creating field for fiscial year between dates- qlik sense script

Hi,

Check this link

Fiscal and Standard Calendar generation

Regards,

jagan.