Create Age buckets in given timeperiod

Tue, 27 Oct 2015 15:58:16 GMT

Hi All,

Two Facts DTL_FCT and T_FCT have small fields PolicyID,ClaimNum and create linktable name(pol_clm) for those two commonfields in qlikview.

EX: 122|56345

I have Claim_PY_Dates(20140101, 20140102) Amounts in DTL_FCT and Age in T_FCT. I have multiple dates in Claim_PY_Dates means (2010,2011 till 2018). I want only Jan'13-Dec'13 as previous year and Jan'14-Dec'14 as current year into qlikview

How to join these in qlikview from two different tables and create a conditional flag on Ageband?? In the real data age is like (1,2,3 ..100)

Output:

Jan'13 - Dec'13	Amount %
0-10	8.0%
11-20	5.0%
21-30	3.0%
30 >	6.0%
Jan'14 - Dec'14	Amount %
0-10	7.0%
11-20	2.0%
21-30	1.0%
30 >	9.0%

1.Calculate sum(Amounts) group by Agebuckets on given a time frame (Jan'13-Dec'13,Jan'14-Dec'14) ??.

Please,suggest how to develop in back end script ?? in a transform layer to make the make front end calculations easier??Please,provide sample if any??

Re: Create Age buckets in given timeperiod

arasantorule — Wed, 28 Oct 2015 07:31:50 GMT

Hi,

You can use intervalmatch() for grouping the ages.

However can you please provide us more details on your request.

The above looks confused.

topic Re: Create Age buckets in given timeperiod in QlikView

Create Age buckets in given timeperiod

Re: Create Age buckets in given timeperiod