topic Re: How to add a calculated field in load script or table box? in QlikView

How to add a calculated field in load script or table box?

Thu, 30 Apr 2015 05:15:54 GMT

Hi there,

I am a beginner.

i want to adds a calculated field 'FY' base on original field 'month' in load script or table box.

the logic is ' if month is November or December, then FY is 'next year', else 'current year.'

thank you in advance!

anbu1984 — Thu, 30 Apr 2015 05:20:36 GMT

In Script,

Load Month, If(Wildmatch(Month,'November','December'),Year(Today())+1,Year(Today())) As FY

From Table;

If you have year field, then replace Year() by year field in above script

sagarkharpude — Thu, 30 Apr 2015 05:21:34 GMT

if(month='November' or month='December',$(vnextyear),$(currentyear)) as FY

Create the variable as vnextyear=year(today()+1)

currentyear=year(today())

jagan — Thu, 30 Apr 2015 06:28:29 GMT

Hi,

Try like this in script

LOAD

If(MixMatch(month, 'November', 'December'), Year(DateFieldName) + 1, Year(DateFieldName)) AS FY

FROM DataSource;

Hope this helps you.

Regards,

Jagan.