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.
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?
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)
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"