Last Date Contact is showing blank values

[#1]

Hi,

I have straight table with columns Last Date Contact and Latest comment

and to populate this I used

Last Date Contact= ContactDate

Latest Comment= FirstSortedValue(Comment,-ContactDate)

These two columns are from same table and the table is in access database. The problem is Last Date Contact is showing blank values for some of the Latest Comment eventhough the dates are present in table.

Could nayone help me do I need to change anything in expression to populate date for each comment.

Thanks.

[swuehl]

Please post some sample data for ContactDate and Comment field (best by posting a small sample qvw application).

Please note that the above expression only work correct, if ContactDate has a numeric representation (like all QV dates should have):

http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right   

[#3]

Please find attached and help me

[swuehl]

I can't really see a problem, please point me to a an issue (ClientID, and the Last Date and Comment you expect, but don't see). There isn't a Comment for every ContactDate in your data.

[#5]

Can you explain a bit more clear as I couldn't able to get this.

[swuehl]

Explain what?

As I said, I can't see a problem with your posted app.

I do get LAST Contact dates that seem to be ok, and I do get Last Comments, when there is a comment for that date in your source data.

While you stated that "max(ContactDate) it's showing incorrect values" and "if the latest comment is having Date means then Latest comment is showing Blank value".

I can't see a problem here, e.g. when looking at ClientID 369210

So, if you want me to help you, you should point me to a ClientID that shows an issue in your table chart (and tell me what you expect to see).

[Clever_Anjos]

Is there such function "LastSortedValue"? I only know FirstSortedValue() and Last()

[rustyfishbones]

Hi,

No sorry I was thinking of LastValue and FirstValue that can be used

Apologies for the confusion

[rustyfishbones]

Does this help you