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