Discussion Board for collaboration related to QlikView App Development.
I hope that you can help me, I'm trying to show in a chart the last entry (i.e. last update) for each record..
i.e. ID1 has 6 updates, I want to show the last. ID2 has 1 update, show the last (and first), ID3 has 4 updates (show the last). But I need to show this for each record, not the last overall.
I hope that you can help me!!
To base on the excel sheet, what I would like to show is for each SUN_ServiceReqID the last update performed. So, for the entry INC000048 the last update date/time would be 18/11/2010 13:59:16. What I'm trying to show, is the last update date/time for each ServiceReqID. So then I'd have an overview:
INC000048 - 18/11/2010 13:59:16
INC000049 - 06/12/2010 11:29:11
INC000050 - 09/12/2010 09:08:38 etc etc...
Hope this clarifies it a bit more.
Hi Dyna ,
Hope this will help you ..
Max(Time(SUN_IH_Update)) as Time
Max(Date(SUN_IH_Update)) as SUN_IH_Update
(ooxml, embedded labels, table is Sheet1) group by SUN_ServiceReqID
(ooxml, embedded labels, table is
If you have only one record that will be the max record . You will get that record using the above logic .If you want to dsiplay it as a single field just concatenate the both.
Ahh... Now that all the data is there, it doesn't seem to work anymore.. I get multiple entries for each AddedBy User... Any ideas? You're help is most appreciated!