HOW TO GET LATEST RECORD BASED ON TIMESTAMP

[#1]

Hi all

I have a requirement of fetching the Customer_ID with the latest time stamp, what ever being the ITEM he had purchased.

Header 1	Header 2	Header 3
ID	ITEM	TIME_STAMP
123	BOOKS	8/18/2015 13:11
123	PEN	8/18/2015 13:58
123	PENCIL	8/19/2015 15:55
999	PEN	7/17/2013 16:44
777	BOOKS	7/27/2015 19:25
777	PENCIL	7/29/2015 12:01
777	BOOKS	7/29/2015 12:01

I HAVE TO DISPLAY THE RECORD BASED ON LATEST TIMESTAMP IN A STRAIGHT TABLE.

please can any one help...!!!

Thanks in Advance

[MK_QSL]

ignore red lines.. It's a bug which has to be fixed by QlikTech.. You just use the expression. You should get the result.

[#3]

Hi Manish,

Even though am not getting output please can you check any other alternative please

Thanks

[MK_QSL]

Let me know after checking the enclosed file..

[#5]

Hi Manish

How do we remove null values for a expression for straight table in qlik view

Thanks

[MK_QSL]

May be something like below

IF(IsNull(YourExpression),0,YourExpression)

Tick Suppress Zero Values in Presentation Tab