Creation of Age buckets in backend script

Mon, 26 Oct 2015 22:13:25 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. In original data Age field is like( 1,2,3...70) etc.

How to join these in qlikview from two different tables and create a conditional flag on Age. Agestarts with (0-10) in to one group and (20-30) into other group and above 30 comes into another bucket

1.Calculate sum(Amounts) group by conditional flag of Age??.

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%

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??

topic Creation of Age buckets in backend script in QlikView

Creation of Age buckets in backend script