Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to compute only max year per pin or owner

I have this data:

PIN     OWNER     YR     YEAR1     TOTALPAY

111      mark          2008     2009       1,000

111      mark          2009     2009       1,000

111      mark          1999     2009       1,000

222     baisah         2015     2016         999

222     baisah         2008     2016         999

222     baisah         2017     2016         999   

I want to sum only data that are underlined and bold. This is my expression but it turns out getting all summation of data. The data should have yr <= year1 per PIN.

Sum({<TotalPay={">=0"}, TotalPen={"<=0"}, PayPenalty={"<=0"}, qtr1={"1","2","3","4"} >}

aggr(DISTINCT if (max(yr)<=year1, TotalPay), TotalPen, PayPenalty,BrgyName,qtr1,year1,Pin3,yr))

0 Replies