Qlik Community

App Development

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

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Ankhi
Creator
Creator

Qlikview: Select a row based on the max value of another column

Hi 

I have a data like below,  this same pattern is repeated for multiple LeaseIDs with different Periods.  For some cases , like Mar-20 here, there are two lines against  the same Type = Cash. In such cases I would only like to pick up the ones with maximum header id i.e Mar-20 , LeaseID=L1 ,Type= Cash should have 350 only .

Can you please help me create a set analysis expression or load script  in Qlikview which will only load filtered data based on max header id as well as Period, Lease Id and Type and Amt.

Header IdLine Id LeaseID Type Period Amt
10011L1CashJun-21100
10112L1AmortMay-21200
10213L1InterestApr-21300
10014L1CashJun-20100
10115L1AmortMay-20200
10216L1InterestApr-20300
10017L1CashMar-20250
12018L1CashMar-20350
10119L1AmortMar-20500
10220L1InterestMar-20430

 

Thanks in advance.

Regards

Ankhi

0 Replies