Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting LAST value in the selected Date Range QLIK SENSE

Hello guys!

I need some help here! Data example:

Store / Date / Stock($)

1 / 2017-01-01 / 1

2 / 2017-01-01 / 2

1 / 2017-01-02 / 3

2 / 2017-01-02 / 4

1 / 2017-01-03 / 5

2 / 2017-01-03 / 6


User selected date range from 2017-01-01 to 2017-01-02

I want to show only the last selected day sum(stock)


Stock($) = 7


I've tryed SUM( {< DATE = {'2017-01-02'} >} STOCK) and this worked, but how to do using "max_date_range variable"?

Thanks!

11 Replies
Not applicable
Author

Thanks!

José_Espinoza
Partner - Contributor III
Partner - Contributor III

What if I'm working with an island calendar? Sorry for bringing this back to life but I'm having an issue like this.