How to write expression to get latest column values

[#1]

Hi Friends,

I have a qlikview file which contains pivot and straight chart items. In one straight Chart I need to get Latest Comment which is getting the latest comments from access database table. But I am not getting the latest comment. suppose if the user added the latest comment today I need to get that in the column value.

I used the below expression to get the latest comment

=MaxString(Comment)

but it's not working as I am getting old comments which are added a few days back.

Could anyone help me in this how to use expression to get the latest comment.

Thanks.

[#2]

Hi Thanks very much it's working.

Amelia

[#3]

Hi,

If I am using FirstSortedValue(Comment,-ContactDate) am getting comments but forename,surname,jointname,staffname are showing blank values. could you please help me in this as it is urgent now please.

[#4]

Please help as I strucked here and couldn't able to get the names for several clients

[Clever_Anjos]

Hello,

forename,surname,jointname,staffname fields are in same table?

Do you have skype? If you have, it would be easier to help, please add me: cleveranjos

[#6]

Hi,

Thanks for this.

forename,surname,jointname are from one table , staffname is from one table and the comment is from another table.

Could you help

As I am in office and  don't have server access to login from my home so that's the reason I couldn't able to login skype from office

Thanks.

[Gysbert_Wassenaar]

That sounds like there are several forenames/surnames/jointnames/staffnames with the same contactdate. In that case you can't use the firstsortedvalue. Perhaps you can concatenate them first:

firstsortedvalue( aggr(concat(forename, ', '),ConcactDate), -ContactDate)

[Clever_Anjos]

Do you have any keys between those tables?

[#9]

Thanks and this is also not showing the names. please help and moreover when I make chages to Live file every time it is decreasing the Live qlikview file size. Is it recommended to reload and save manually apart from reload engine? Could you please let me know.

[#10]

Yes I have keys in names table and to join all these columns I used Link Table.

Thanks.

[Clever_Anjos]

Is it possible to post a sample of your app?