Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Solved this by attaching leading zeros to the comments in the database like this: 00000012|Comment
Then in expression using =subfield(max(Comment), '|', 2)
Solved this by attaching leading zeros to the comments in the database like this: 00000012|Comment
Then in expression using =subfield(max(Comment), '|', 2)