Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, all,
Just noticed that I can not use "Advanced search" like before after I update to use QV 11.20 SR12, the expression input box dose not pop-up after click the search icon as in the attached pic as before.
Dose any one knows how to get the pop-up window?
After some try, it seems sometimes, the pop-up input box do appears, but most time appear at the top of the sheet, not at the top of the list box, that is really strange behavior.
But there is still problem. After I use expression like "=sum(amount)>2000"to filter to get the correct list, after press "Enter", it will always select all, but not the value match the expression.
Dose any one have any idea about this?
Thanks very much
Zhihong
goto your listbox Definition, tab general
use "Default search mode" and select "use associative search"
Just noticed that sometimes, the pop-up input box do appears, but most time appear at the top of the sheet, not at the top of the list box, that is really strange behavior.
Rudolf,
Thanks for your quick reply.
Tried, but still the same strange behavior as I described below.
Though the pop-up window still appears at top of the sheet, but today the dynamic expression works, and after press 'Enter', the field is filtered as I want. Though have no idea why it works today, maybe this is related to the cache, or memory?
in your image you see the >> icon rite? click on that ..you should get the option which will allow you to search in the other fileds.
Hope this helps you
Hi, the pop-up at the top of the sheet is strange, I can't reproduce that behaviour (I made it in a simple document, so it's possible that it works nice on a simpler document, maybe in a complex document it stops working as expected).
About the expression...can you check if it was because of casing? i.e.: Sum(amount) instead of Sum(Amount)
Is your listbox using a field from your data model or is the listbox using an expression?
Some listbox functionality is not available if the listbox is based on an expression. Also some functionality is not available is the field is a key field that links two tables.
Frequency is not available for key fields nor for listboxes using expressions.
Hi, Avinash,
Thanks for the tip. Can use this to filter other field if needed.
But for my case I only need to filter the field in the "List Box", so do not need this function. And it dose not work last time when I use it. But now it works and can filter the field in the "List Box"
Zhihong
Hi ,
Are you using any expression that List box? if so it does not work... to make that work go to list box properties > General>Search>In default Search Mode>Select use Wildcard search
Hope this helps you