topic Re: Search for Max Date in QlikView

Search for Max Date

Anonymous — Fri, 12 Jun 2015 21:01:49 GMT

I'm trying to create a bookmark that includes the max date selection in the following ListBox, but no matter how many different ways I do it, it never seems to work. I must be missing something obvious. Any ideas?

(Yes, the actual field name has the underscore.)

Re: Search for Max Date

swuehl — Sat, 13 Jun 2015 13:24:48 GMT

Have you tried with the total qualifier?

=Max({1} TOTAL Record_Date)

Since you don't want to see the max per Record_Date (which would be the date itself), but the max of the TOTAL list.

edit: I've overseen that this will also return all field values, try

=Record_Date = Max({1} TOTAL Record_Date)

Re: Search for Max Date

Anonymous — Mon, 15 Jun 2015 19:33:59 GMT

Yep, this is what I ended up as well. However, when I save this search as a bookmark, it saves the current value rather than the actual search string. So tomorrow, the 16th, the bookmark will still be selecting the 15th.

=Record_Date = Max({1} TOTAL Record_Date)

Re: Search for Max Date

MarcoWedel — Mon, 15 Jun 2015 23:20:34 GMT

interesting. These threads suggest that it should be possible:

The Search String

Re: Bookmark based on complex queries

I couldn't reproduce it either.

regards

Marco

Re: Search for Max Date

swuehl — Tue, 16 Jun 2015 11:58:44 GMT

OMG.

Seems to me like QV is inconsistently handling advanced search expressions when creating a bookmark.

In the defect database, they were talking about entering a different search mode when the formula returns only a single value, and that it's working as designed.

I don't think anyone ouside QV development understands this (especially when the current selection box is actually displaying the search before saving a bookmark).

I've tested with an older version of 11.20, storing the advanced search in a bookmark worked out of the box.

In 11.20 SR11, you'll need to enable the easter egg mentioned in this thread.

Though it's also mentioning that there might be side effects from other defects (haven't checked all these defect numbers for content).

Re: Search for Max Date

Anonymous — Tue, 16 Jun 2015 19:45:06 GMT

Unfortunately, we are still at SR7. Sounds like we'll need to get upgraded. Thanks for your help with this.