Discussion Board for collaboration related to QlikView App Development.
Good Afternoon from the East Coast USA,
While this is almost complete, I am still missing "USER" which should not be the case as everyone should match. Here's the goal.
In this chart, using the data (table shown), Count (session) - works, get last user time (works), get the user associated with that row (doesn't ). (See below)
Any assistance is appreciated in advance.
EndDTSCombo - is a Timestamp column. (that is what I'm using for "last session" (above)
only(If(EndDTSCombo = Max(TOTAL EndDTSCombo), DisplayNM))
didn't work. So far - closest is
only(If(Date = Max(TOTAL Date), DisplayNM))
--if I could use "timestamp with the above - think that will do it.
Thanks for the "try this".
It did give me names - now , I just need to verify.
On other note, I did find the "first sorted value" - but it wasn't matching the MAX(DATE) - let me see if this worked.
I really appreciate you suggesting and assisting me with the "firstsortedvalue". It appears to match 2 of my rows. Now, for final validation.
Have a good weekend.