Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Max and Lookup in Straight Table

Can someone help me return the correct SG_Status based on the max(SG_ID)?  The answer in the form of a straight table would be as follows, but I don't know how to solve for it. As you can from my file see I only return nulls with the exception of the first row

Report_ID
max(SG_ID)SG_Status
100011
100122
100233
10044

2

Thanks

1 Solution

Accepted Solutions
danielrozental
Honored Contributor II

Re: Max and Lookup in Straight Table

Try firstsortedvalue(SG_Status, -SD_ID)

2 Replies
danielrozental
Honored Contributor II

Re: Max and Lookup in Straight Table

Try firstsortedvalue(SG_Status, -SD_ID)

Not applicable

Re: Max and Lookup in Straight Table

Thanks Dan, you were right even though my model above was wrong. I wish I could give you double points for that!

Community Browser