Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
olguita2014
Creator
Creator

last record by date range

Hi,

Please help me!!!!!!.... I want to get the last record of city  by date range. Example:

I have this information:

vehicle modelcityDATE
AAAA11/2/2017
AAAA228/2/2017
AAAA323/2/2019
BBBB118/2/2017
BBBB223/3/2018
BBBB317/2/2019

 

and when I choose one date, for example 23/3/2018 (rate of dates less or equal to the current selection) the result should be:

DATE 23/3/2018

vehicle modelcity
AAAA2
BBBB2

 

if i select this DATE 23/2/2019

 

vehicle modelcity
AAAA3
BBBB3

 

Labels (1)
0 Replies