Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
QV11 SR1 64-bit
I have 2 fields::
Field1 JobTitle in Listbox
Field2 JobFunction Dimension within Straight Table Chart
My users would like to be able to search and select within both of these at the same time using OR logic, so the following sort of thing...
=[JobTitle ] like '*Manager*
OR
[JobTitle ] like '*Director*'
OR
[JobFunction] like '*Executive*'
OR
[JobFunction] like '*Management*'
The straight table chart does not itself have an advanced search option.
So if i right-click the JobTitle listbox and choose Advanced Search with the Search in drop-down set to JobTitle, using the statement above i get some results which at first glance appear correct (3223 record count)
However, if i change the Search in drop-down to JobFunction and try the same thing i get different results (2565 record count)
Does anyone have an idea why that might be?
Is there another way for the user to do this kind of thing e.g. a set analysis expression?
Is the advanced search you created case sensitive?