Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem in Base Year wise Dynamic records Generation

Hi Guru's

Logic :if(Year)>=2015, as per contract Term it should generate records

Airtel Project base Year(Start year)=2013 ->its Less than 2015 then one record

TATA Docomo Project base Year(Start year)=2014->less than 2015 then 2 records(as Source entry)

Vodafone project base Year(Start year)=2015->=2015 then 3 records because 3 Years Contract

Issue:TATA Docomo Project base year is 2014 its less than 2015 but in source file they entered 2 records

       Then 2014,2015 records are came

     as per logic base Year >=2015  it will generate rows based on contract term(2 Year).so 2016 record is coming ,that is not required .

need to display 2 records only for TATA Docomo Project(2014,2015)

More Information refer attached sample application

Labels (1)
3 Replies
Anonymous
Not applicable
Author

this is tricky .

Anonymous
Not applicable
Author

Attached is the solution.

Anonymous
Not applicable
Author

let me know if that fixed your issue or else i can help you ...