Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.