Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Year Vs New Year ,which one i need to keep as filter object

Hi Guru's,

i have data like this


Year      Project Type      contract Term

2013          Expense       3 year

2013          Carry over     3 Year

Requirement:For Carry over project need to show 3 records like 2013,2014,2015

example:

Year      Project Type      contract Term

2013          Carry over     3 year

2014          Carry over     3 Year

2015          Carry over     3 Year

i solved this issue .

But for Expense project it should display one record as Given:

2013          Expense       3 year

present Problem:

while creating carry over records i created new year field to show extra records

now i have Year,new year fields as filters

Selection criteria:if project type is expense  then one record if project type is carry over 3 records

in this scenario which one i need to keep as filter? year or New year

please find the sample application

0 Replies