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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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!