Qlik Community

New to Qlik Sense

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

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajbhc
Contributor
Contributor

Incorporating Temporal Data into Dashboard

Hi all,

I have a dataset that used to contain only one date field per id and now I want to add a temporal element where a user can select any date and the metrics would reflect only those that would be have been considered “most recent” for their chosen date.

The data looks like this

ajbhc_1-1651256763157.png

I want it to work so if the user chooses 5/10/2020 as their date only the highlighted rows get summed.

ajbhc_2-1651256763170.png

Whereas if the selected date is 10/12/2017 it is like below.

ajbhc_3-1651256763180.png

 

Thanks for the help.

Labels (5)
2 Replies
vinieme12
Champion III
Champion III

Can you define "most recent" logically?

Like n number or months forward/backward

We need a logically definition to build anything

Why wasn't ID=8 consider as recent in second scenario?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
ajbhc
Contributor
Contributor
Author

Most recent meaning the date closest to the selected date thats already happened.

 

ID = 8 is not selected in the second scenario because 9/9/2018 occured after the selected date (10/12/2017)

 

Thanks.