Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create Age buckets in given timeperiod

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'13Amount %
0-108.0%
11-205.0%
21-303.0%
30 >6.0%
Jan'14 - Dec'14Amount %
0-107.0%
11-202.0%
21-301.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??

1 Reply
arasantorule
Creator III
Creator III

Hi,

You can use intervalmatch() for grouping the ages.

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

The above looks confused.