Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem to list a specific line in graphic tables

Hi

New Qlikview user.

I have a graphic table whit products and some dates of sales.

I want to show in a table graphic just the lines whit information whit the date of the last sale of all products that I have in my graphic.

Example whit the information that I have:

Product - Date of sale

1 - 10/10/2008

2 - 29/09/2009

1 - 03/09/2009

1 - 04/05/2009

2 - 02/02/2009

What I want to list in graphic table:

Product - Date of last sale

1 - 03/09/2009

2 - 29/09/2009

Sorry my English.

Thanks and regards.

2 Replies
kji
Employee
Employee

Not sure if i understand the question, but im guessing a table with Product as dimension and Max(Date of sale) as expression ss what you are looking for.

Not applicable
Author

Thanks

I use max and worked well whit the date sale information (Using 2 informations).

Now I need to put another information in this graphic and list only for the last date of sale.

When I put the other parameter (Quantity of products ) the table is showing all of dates sales again.

Thanks.