Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Finding the newest value

Hi,

I have a simple table consisting of 3 fields (Container, Status and reload date). Every day the table is expanded with an extra day.

I would like to make a object that shows me the newest status for each container.

See attached file for details.

The result should be:

Container      Status

A                  1

B                  3

C                  4

Thanks.

BR

Jakob Hjorth-Hansen

13 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

D V,

Your blog is really good. Today i learned the concept of FirstSortedValue, Thanks to share with us.

IAMDV
Luminary Alumni
Luminary Alumni

Jagan,

Thank you for the kind words. I'm glad you have learnt something new. Please can you email me directly at dvadithala@gmail.com.

Cheers - DV

Not applicable
Author

I have seen your site many times and I have learnt so much from there. what a Gr8 work you are doing

thanks to sharing

- IndianQvLover

IAMDV
Luminary Alumni
Luminary Alumni

Jakob & All - I understand that we have already got this working by FirstSortedValue() function. But I thought it will be good to use Set Analysis with Indirect Analysis.

MaxString({<[Reload date] = (P({<Status ={$(=max(Status))} >}))>} Status)

Cheers,

DV