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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
alexandros17
Partner - Champion III
Partner - Champion III

Sum where max

Hi,

there is a situation I never experienced before,

There is a customer, its value and its Sold Date, for each customer I have to find the values corresponding to max date.

I Always solved the problem in the script (in a very sinple way), now I am trying to write an expression to solve the question in the front end, I nearly did it but there is still a field I do not want to see. Is it possible to achive the result without including DateSold field as dimension? I do not want to hide the field, I do not want to include it!

Refer to the attached qvw.

Thanks

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try FirstSortedValue(Value, -DateSold)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try FirstSortedValue(Value, -DateSold)


talk is cheap, supply exceeds demand
alexandros17
Partner - Champion III
Partner - Champion III
Author

Great!