Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Dayna
Creator II
Creator II

How to show last update for each record...?

Dear all,

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!!

Kind Regards,
Dayna

1 Solution

Accepted Solutions
Not applicable

Hi Dayna,

see the attached example.

Maybe it gives an idea how you can get what you want.

Good luck!

Rainer

View solution in original post

15 Replies
maneshkhottcpl
Partner - Creator III
Partner - Creator III

Hi,

Can u send the sample application/data?

Dayna
Creator II
Creator II
Author

Hello Manesh,

Please find attached.

Kind Regards,
Dayna

maneshkhottcpl
Partner - Creator III
Partner - Creator III

Hi Dayna,

Sorry, but i need more explanation to resolve ur problem.

can u explain me wit examples.

Thanks

Manesh

Dayna
Creator II
Creator II
Author

Hello Manesh,

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.

Kind Regards,
Dayna

Not applicable

Hi Dyna ,

Hope this will help you ..



LOAD

Max

(Time(SUN_IH_Update)) as Time

,

Max

(Date(SUN_IH_Update)) as SUN_IH_Update

,

SUN_ServiceReqID

FROM

(

ooxml, embedded labels, table is Sheet1) group by SUN_ServiceReqID

;

left

join

LOAD



SUN_IH_AddedBy

,

SUN_ServiceReqID

FROM

(

ooxml, embedded labels, table is

Sheet1);

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.

Regards,

Chakravarthy.





Dayna
Creator II
Creator II
Author

Hello Chakravarthy,

That looks like it's done the job! Many thanks!

Kind Regards,
Dayna

Dayna
Creator II
Creator II
Author

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!

Kind Regards,
Dayna

maneshkhottcpl
Partner - Creator III
Partner - Creator III

Hi,

Dayna, please use the code which is send by me in application. It will work 100%.

maneshkhottcpl
Partner - Creator III
Partner - Creator III

Dayna,

Please refer the application attached.