Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Max Function

Hello,

In an expression, I am trying to determine whether a SKU is Import or Domestic with the field, [PO Imp/Dom] which will give me either "I" or "D" for the last [PO Entry Date]. I would like to know how to determine whether or not a SKU is an "I" or a "D" based on the max [PO Entry Date].

Any help would be greatly appreciated!

Isabel

1 Solution

Accepted Solutions
venkatg6759
Creator III
Creator III

Use firstsorted value 

Firstsortedvalue([PO Imp/Dom] ,-[PO Entry Date])

View solution in original post

3 Replies
venkatg6759
Creator III
Creator III

Use firstsorted value 

Firstsortedvalue([PO Imp/Dom] ,-[PO Entry Date])

Anonymous
Not applicable
Author

Thanks!

eduardo_sommer
Partner - Specialist
Partner - Specialist

Use this:

if(firstsortedvalue([PO Imp/Dom ], -[PO Entry Date])='I', 'Imported', 'Domestic')

Eduardo