Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
turodionova
Contributor III
Contributor III

Sales Data for max Date

Hi!

I need to create report with sales data by customers related to the latest sales date for each.

Yellow lines in the table below are what i need to extract.

Capture.PNG.png

I use an expression: aggr(max(Date),[Customer]) and get right date for every Customer.

Then i try to use this expression for sales data: sum({$<Date={"=aggr(max(Date),[Customer])"}>}Sales) 

and get a wrong result.

Thanks in advance.

10 Replies
MK_QSL
MVP
MVP

FirstSortedValue(Sales,-Date)

Agis-Kalogiannis
Employee
Employee

Was it exactly what you were looking for Tamara? Did it work?

turodionova
Contributor III
Contributor III
Author

Hi, Agis!

It does not work unfortunately in my case. I guess some grouping is

needed?

Kind regards

Tamara Rodionova

Colgate-Palmolive Russia.

Senior Sales Analyst

Office phone +7495 937 11 00 (ext. 2-822)

MK_QSL
MVP
MVP

Provide few more data which showing that this is not working.... This should work on the sample data you have provided.

turodionova
Contributor III
Contributor III
Author

Sales - ,

Date - Дата

Kind regards

Tamara Rodionova

Colgate-Palmolive Russia.

Senior Sales Analyst

Office phone +7495 937 11 00 (ext. 2-822)

ecolomer
Master II
Master II

here you have an example for this

MK_QSL
MVP
MVP

Can you create little dummy data and pass to us? Your application is difficult to understand..

turodionova
Contributor III
Contributor III
Author

Manish, your expression works in a model with dummy data, so the issue is

in my application.

I will try to identify, thanks for your help.

Kind regards

Tamara Rodionova

Colgate-Palmolive Russia.

Senior Sales Analyst

Office phone +7495 937 11 00 (ext. 2-822)

turodionova
Contributor III
Contributor III
Author

Manish, it worked, but as soon as i concatenate additional value, it

stopped working.

Kind regards

Tamara Rodionova

Colgate-Palmolive Russia.

Senior Sales Analyst

Office phone +7495 937 11 00 (ext. 2-822)