topic LISTBOX Search Expression - Latest Day in QlikView

LISTBOX Search Expression - Latest Day

Anonymous — Wed, 24 Aug 2011 04:55:10 GMT

I have an attribute called YMDSTRING with days in it. The expression MAXSTRING(YMDSTRING) returns the latest day ( eg 2011-08-23 as of the writing of this note). I have tried using this in as search expression in a YMDSTRING listbox with no luck. Why? If i type in 2011-08-23 i get the value i want. Ultimately i want an expression that returns only the latest day in a listbox with days in it! Thanks!

LISTBOX Search Expression - Latest Day

Anonymous — Wed, 24 Aug 2011 21:06:56 GMT

Bump for daytime folks (in North America )

LISTBOX Search Expression - Latest Day

Wed, 24 Aug 2011 23:13:29 GMT

Hi twebber ,

correct me if i'm wrong you want a latest date of your ymdstring

Can you try this Date#(min(YMDSTRING))

thanks

Meher

LISTBOX Search Expression - Latest Day

swuehl — Wed, 24 Aug 2011 23:30:48 GMT

I also have often hard times with search expressions, I don't find it really intuitive.

Anyway, I think

=YMDSTRING=maxstring(total YMDSTRING)

could work as search expression (enter all characters as shown). At least it works here 😉

Regards,

Stefan

Re: LISTBOX Search Expression - Latest Day

Anonymous — Wed, 24 Aug 2011 23:38:00 GMT

It doesn't work swuehl. Like all my attempts the whole list turns green (which is odd because its as if the whole list matches but I dont think that is the case...). Note, I only have one row in my list that is the maximum so this something should work. If I type if 2011-08-23 in the serach box it will work. If I put =maxstring(YMDSTRING) in a text box object to see what it evaluates to, it will be 2011-08-23. What gives!

LISTBOX Search Expression - Latest Day

swuehl — Wed, 24 Aug 2011 23:41:11 GMT

I assume you used the - crucial here - total qualifier? Without total, I think the maxstring is evaluated per row, returning all dates.

If you did, I don't have a clue yet.

LISTBOX Search Expression - Latest Day

Anonymous — Wed, 24 Aug 2011 23:49:48 GMT

Very strange. It worked this time. When i tried it a few minutes ago, my typing was lagged. I think my machine was hurting for memory. Anyway, i shut down some applications including QV, started it again and it worked. Thankyou. It sorta bugs me that an application wont work properly when the machine is low on resources without warning. Hmm.