Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
Hi,
You can use intervalmatch() for grouping the ages.
However can you please provide us more details on your request.
The above looks confused.