Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I pull the value of a field where there is a Max Date for that row?

Hi everyone,

I am trying to pull in Flash Reports which all link together by the Project Number. So one project can have multiple Flash Reports. I want to display the value of the a particular field according to the max date.

The problem is, I currently have flash reports for march 2013 for all of the projects as an example, but if one project has a flash report for october 2013, then it is the max date and therefore it pulls in that field but only for that project and not the others. Each project should have it's own max date and diffrentiate from one another so that it pull in literally the field according to that max date of that particular project (or row)..

Does someone know how to do this?

Many thanks,

Bruno Pereira

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Create a straight table

Dimension =

Project Number

Expressions

FirstSortedValue(Date,-Date)

and

FirstSortedValue([RAG Status],-Date)

View solution in original post

4 Replies
MK_QSL
MVP
MVP

Can you share your sample data or apps please?

Not applicable
Author

I have something similar to this. There would be an individual excel sheet for each row of the second table. I just done it like this to simplify.

So for project number 1, I would expect the RAG to be 2. For Project 2, I would expect 3. And for project 3, I would expect 2.

Project NumberNameDate
1Test 101/02/2014
2Test 201/02/2014
3Test 301/02/2014

Project NumberDateRAG Status
103/03/20141
105/04/20142
201/03/20143
209/04/20141
202/05/20143
314/03/20141
320/04/2014

2

MK_QSL
MVP
MVP

Create a straight table

Dimension =

Project Number

Expressions

FirstSortedValue(Date,-Date)

and

FirstSortedValue([RAG Status],-Date)

Not applicable
Author

Thank you Manish! You're a genius!