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
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
saminouari
Contributor III
Contributor III

Get last value max date

Hi, 

I want to get the last value from the latest date, for example : 

This is my table

Store,Date, Value
BOULANGER AGEN, 03/06/2019, 1
BOULANGER AGEN, 13/06/2019, 1
BOULANGER AGEN, 26/06/2019, 1
BOULANGER AGEN, 26/06/2019, 0
BOULANGER AGEN, 17/07/2019, 0
BOULANGER AGEN, 17/07/2019, 2
BOULANGER AGEN, 30/07/2019, 1

This is the result I want

Store, Max Date, Last Value
BOULANGER AGEN, 30/07/2019, 1

 

I tried FirstSortedValue but it didn't work.

2 Solutions

Accepted Solutions
sunny_talwar

Front end solution

image.png

View solution in original post

sunny_talwar

Max(Date) is an expression, not a dimension... you seem to be using it as a dimension

View solution in original post

5 Replies
sunny_talwar

In the script or front end

saminouari
Contributor III
Contributor III
Author

@sunny_talwar  Both solutions work for me, I want to display the last value from max date of each distinct store.

sunny_talwar

Front end solution

image.png

saminouari
Contributor III
Contributor III
Author

@sunny_talwar  Your solution work fine, but when I tried to replicate it, it didn't work. I think I have a problem with the DateFormat.

 

clipboard_image_0.png

clipboard_image_1.png

sunny_talwar

Max(Date) is an expression, not a dimension... you seem to be using it as a dimension