Showing latest comment with direct discovery

[#1]

Hi,

I have user comments in a sql server table and I am loading them into qlikview with direct discovery. I want to show the latest comment in a straight table, but since I can't use set analysis or qv-functions like only() with DD I am a bit stuck. Is it possible to create this with some trick? I can use max(Comment) to get the first comment in alphabetical order.. not really useful though.

I have seen Direct Discovery: Workarounds for Set Analysis (1/3) but I can't use this into my usecase. Can this be solved with some special tricks?

//Micke

[#2 · Accepted solution]

Solved this by attaching leading zeros to the comments in the database like this: 00000012|Comment

Then in expression using =subfield(max(Comment), '|', 2)