Hi, I have 2 qvws that are pretty much the same except 1 loads data from excel in the script and the other SQL from an Oracle DB.
Now both have a series of button with an expression to generate the text of the button. Each button represents a team member. I'm using a set expression to display the count of items for each team member based on the current selection. So the expression is:
=Count({$<[TEAM_MEMBER]={'*John*'}>} [ID])
Without any selection, the expression returns correct results. If I make selections, the numbers adjust correctly..... EXCEPT......
If the selection I make is a team member then I would expect all to become 0 apart from the one for the team member that has been selected.
In the qwv pulling data from excel, it all works as expected and if I select a team member then all go to 0 except the chosen person.
In the qwv pulling data from ORACLE, all works great apart from when I add a selection for team member. The result returned for each is as though I haven't selected a team member. The figures correctly adjust if I choose other selections but the team member selection is being ignored.
The Oracle qwv was a copy of the excel qwv and then the script changed etc. I doubt the script has anything to do with it, but it's the only thing I can see which is different.
Both are actually working correctly. I've realised that the 'if' part of the statement is actually a modifier which changes the selection and so overrides the selection if I have a team member selected.
The reason why one file sets the results to 0 is because I have 2 fields that refer to the team member and the selection was using the second whereas the 'modifier' in the set analysis was using the first (so technically a different field!!).
Both are actually working correctly. I've realised that the 'if' part of the statement is actually a modifier which changes the selection and so overrides the selection if I have a team member selected.
The reason why one file sets the results to 0 is because I have 2 fields that refer to the team member and the selection was using the second whereas the 'modifier' in the set analysis was using the first (so technically a different field!!).
