Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

issue with generation of records based on contract term

Hi All

if Year =2014 and Contract term is 3 Years,iam generating 2014,2015,2016 as New year Field .

But if i select  Expense in Capital Vs Expense  field, it should show data only for  2014 . no need to generate 3 records. i Can't use old year field because iam using New year field for further calculations

how to achieve this

Please find the sample application as attachment

Thanks in advance

0 Replies