Discussion board where members can get started with QlikView.
Could someone help me to display only the
ID, DATE, MESSAGE
1,10/11/2012 12:00:56, YES
1,10/11/2012 12:04:43, NO
And I want to create something like this:
1, 10/11/2012 13:10:02, YES,
2, 12/11/2012 14:20:02, YES
I need only the last time when ticket was updated to be displayed in a streight table.
I tried to use the Max(DATE) in the chart to sort them but I want to restrict the data from the load script. Any advises?
Thansk in advance!
LOAD * Inline
FirstSortedValue(DATE, -DATE) as Date,
FirstSortedValue(MESSAGE, -DATE) as Message Resident A Group By ID;
View solution in original post
May be this
Right Join (Fact)
Max(DATE) as DATE
Group By ID;
Thanks for it, works now using this