Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
I'm trying to filter the last order status customers. Except that nothing in the manual about the last date to be selected, only loading.
Below is an example of what I need.
Sample database:
NAME | IDENTIFICATION NUMBER | PRODUCT | DATE | STATUS |
JOSE | 5424658 | SHIRT | 02/04/2015 | DELIVERED REQUEST |
MARIA JOSE | 5169469 | TENNIS | 20/03/2015 | AWAITING DELIVERY |
MARIA JOSE | 5169469 | TENNIS | 24/04/2015 | DELIVERED REQUEST |
JOAQUIM | 498562 | TENNIS | 17/04/2015 | DELIVERED REQUEST |
Anastacia | 892323 | BLOUSE | 04/05/2015 | AWAITING DELIVERY |
JURESMAR | 985620 | SHIRT | 20/03/2015 | AWAITING DELIVERY |
MARIANA | 5156623 | SHIRT | 11/05/2015 | DELIVERED REQUEST |
JOHN | 5159396 | SHOE | 22/05/2015 | AWAITING DELIVERY |
When filter by status:
NAME | IDENTIFICATION NUMBER | PRODUCT | DATE | STATUS |
JURESMAR | 985620 | SHIRT | 20/03/2015 | AWAITING DELIVERY |
JOHN | 5159396 | SHOE | 22/05/2015 | AWAITING DELIVERY |
Anastacia | 892323 | BLOUSE | 04/05/2015 | AWAITING DELIVERY |
MARIA JOSE | 5169469 | TENNIS | 20/03/2015 | AWAITING DELIVERY |
Real status:
NAME | IDENTIFICATION NUMBER | PRODUCT | DATE | STATUS |
JURESMAR | 985620 | SHIRT | 20/03/2015 | AWAITING DELIVERY |
JOHN | 5159396 | SHOE | 22/05/2015 | AWAITING DELIVERY |
Anastacia | 892323 | BLOUSE | 04/05/2015 | AWAITING DELIVERY |
This might be what you are looking for?
Expressions:
Latest Update: Max( DATE )
Status: Max( Status )
Process: Concat( Date( DATE , 'YY-MM-DD' ) & ' : ' & STATUS , ' / ', DATE )
You need this in an object or in script?
Could you please send a reduced qvw copy?
I assume that 'MARIA JOSE' should be excluded because the 'AWAITED DELIVERY' is not the latest status.
If this is correct, you maybe want to create a "Latest Status" flag in the script, and on the front-end objects use this flag as a condition (set analysis) to show the records where this flag is true.
Or maybe you want to load only the records with the current status? I can't guess the exact requirements...
This might be what you are looking for?
Expressions:
Latest Update: Max( DATE )
Status: Max( Status )
Process: Concat( Date( DATE , 'YY-MM-DD' ) & ' : ' & STATUS , ' / ', DATE )
Hi,
one solution could be:
hope this helps
regards
Marco
Another approach that is similar to Marco's solution:
get the maximum of dates and group by names then left join.
And in the expression, just use if max date is equal to date to pull the most update status.
Just another approach.
it would be better on an object , I could accomplish in Excel using dynamic table , sorting by date, and deleting duplicates .
Thanks! I managed to make the filter, follow the steps that you put in qvw.