Qlik Community

App Development

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Ankhi
Creator
Creator

Select a row based on 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 LID Type Period Amt
10011L1CashJun-21100
10112L1AmortMay-21200
10213L1InterestApr-21300
10014L1CashJun-20100
10115L1AmortMay-20200
10216L1InterestApr-20300
10017L1CashMar-20250
12018L1CashMar-20350
10119L1AmortMar-20500
10220L1InterestMar-20430

 

Thanks

Ankhi

0 Replies