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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Svetlana1
Contributor
Contributor
‎2019-02-20 06:21 AM

Set analysis does not limit data by date. FirstSortedValue

Hey, guys. How do I display the last price of an item on the date of sale? Unable to set a date.

FirstSortedValue(${DateSales={"">=$(Max(DatePrice))""}}price,-DatePrice)

Last price.qvf
1,220 Views
0 Likes
5 Replies
sunny_talwar
MVP
MVP
‎2019-02-20 07:00 AM

What if there are two prices for a particular DateSales with Max DatePrice?

image.png

1,213 Views
0 Likes
Svetlana1
Contributor
Contributor
‎2019-02-20 07:32 AM
Author

In response to sunny_talwar

display the maximum price

1,207 Views
0 Likes
Svetlana1
Contributor
Contributor
‎2019-02-20 07:40 AM
Author

In response to sunny_talwar

So trying to withdraw, and always shows the last price

26 KB
1,206 Views
0 Likes
sunny_talwar
MVP
MVP
‎2019-02-20 08:12 AM

In response to Svetlana1

Not sure I understand your requirement?

1,198 Views
0 Likes
Svetlana1
Contributor
Contributor
‎2019-02-20 08:42 AM
Author

In response to sunny_talwar

Example,
at the DateSales 02.06.2018 и 10.06.2018 to bring the price from DatePrice 05.05.2018
Since the DateSales 02.06.2018 the price of the product was 0.05

at the DateSales 09.07.2018 to bring the price from DatePrice 04.07.2018
Since the DateSales 09.07.2018 the price of the product was 0.02

32 KB
1,194 Views
0 Likes