Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to get Mouse position in QV 8.5?
I have table with some measures, when user click on one digital in table, he want to see the detailed information on this digital which he clicked on.
We can get which dimension we select, but how about measures???
Thanks.
I got now an answer from Support: The mentioned behaviour has been verified as bug 23520; it will presumably be resolved in SR2. So we have to wait for the macro solution until then unfortunately.
Rgds,
Joachim
Hi Ben,
if I understand your problem ocrrectly, far it seems to me that you don't need the mouse position. I had a similar problem where I wanted to show details in Table Box B when a selection was made in Table Box A. I solved this problem with a conditional "Show" in Table Box B:
count(DISTINCT FIELD_TO_SELECT)=1
The Table Box B with the details then only shows if only one value of FIELD_TO_SELECT is selected.
Perhaps this might help,
Rgds
Joachim
Hi Ben,
this also works with straight or pivot table. Find enclosed a little demo, perhaps it helps. The detail table only shows when only one country in the pivot table selected.
Rgds,
Joachim
Hi Ben,
I added the field Continent and another detail table to my sample. Now, if you select one continent in the pivot, the detail table with Continent shows, if you select (additionally) one country, the detail table with country shows (additionally). The key to this is the function GetSelectedCount(Field).
You meke a conditional show in the two detail tables: GetSelectedCount(Country) = 1 in the first one and GetSelectedCount(Continent) in the second one.
Rgds,
Joachim
OK, I think now I've got you, sorry for my misunderstanding. Perhaps there is a possibility by grouping the Expressions and then checking which expression of the group is selected; with named document groups that wouldn't be a problem using GetSelectedField; with grouped expressions I have to think about it, perhaps there's a possibility with API and a macro; I'll think about it.
Rgds,
Joachim
Hi Ben,
just to keep you informed: I tried to make a demo as described, but the macro didn't work; there were strange results, and I opened a support case concerning CycleGroupPos. I'll keep you informed and in case of a solution will try to finalize my demo if you like and haven't already solved your problem.
Rgds,
Joachim
Many thanks......
May I have your IM Account?
My MSN: mascotzhuang@hotmail.com
🙂