topic Re: Master Calender in QlikView

Master Calender

upaliwije — Thu, 27 Aug 2015 07:32:03 GMT

In my QV document I have following field amongst others

POLICY_PERIOD

Jan-15-Jan-16

Feb-13-Feb-14

Apr-14-Apr-15

I want this field to joined to Master Calender and extract the undermetioned field

policy_year

2015-2016

2013-2014

2014-2015

Pls help me to write script for master calender

Re: Master Calender

tresB — Thu, 27 Aug 2015 07:44:41 GMT

SubField(POLICY_PERIOD, '-',2)+2000 & '-' SubField(POLICY_PERIOD, '-',4)+2000 AS policy_year

Re: Master Calender

sunny_talwar — Thu, 27 Aug 2015 07:44:53 GMT

May be something like this in the script:

Fact:

LOAD *,

Left(Replace(Replace(KeepChar(POLICY_PERIOD, '0123456789-'), '--', '20'), '-', '20'), 4) & '-' &

Right(Replace(Replace(KeepChar(POLICY_PERIOD, '0123456789-'), '--', '20'), '-', '20'), 4) as policy_year;

LOAD * Inline [

POLICY_PERIOD

Jan-15-Jan-16

Feb-13-Feb-14

Apr-14-Apr-15

];

MasterCalendar:

LOAD * Inline [

policy_year

2015-2016

2013-2014

2014-2015

];

Re: Master Calender

Anonymous — Thu, 27 Aug 2015 07:58:06 GMT

You Can try something like this:

MasterCalender:

load

POLICY_PERIOD,

'20'&mid(POLICY_PERIOD,5,2)&'-'&'20'&mid(POLICY_PERIOD,12,2) as YEAR

Resident TableName;

Re: Master Calender

d_koti24 — Thu, 27 Aug 2015 08:21:59 GMT

Hi ,

period:

LOAD * Inline [

POLICY_PERIOD

Jan-15-Jan-16

Feb-13-Feb-14

Apr-14-Apr-15

];

master:

load

POLICY_PERIOD,

20&''&SubField(POLICY_PERIOD,'-',2)&'-'&20&''&SubField(POLICY_PERIOD,'-',-1) as POLICY_PERIOD

Resident period; !