How to get Mouse position?

[#1]

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.

[biester]

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

[#3]

Thanks for your reply, but how to deal with in pivot table and straight table?

[biester]

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

[#5]

That's great, if I add a collumn "Margin", how to know I select "Sales" or "Margin"? I select one row "Sales", Sales Detailed table is shown as well as "Margin". Regards.

[biester]

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

[#7]

I think I make you confused, could you please add an expression, not a field. For example, Filed ( Country ), Expression ( Sales Amount, Margin Amount, Cost Amount ). Now, we have 1 filed, 3 expressions in pivot table. When I click on column Margin Amount, Margin Amount Detailed table is shown. When I click on column Sales Amount, Sales Amount Detailed table is shown. The final users want to clik on one number in pivot table, then show it's detailed information, unfortunately, users click on expressions ,not filed. 😞

[biester]

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

[biester]

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

[#10]

Many thanks......

May I have your IM Account?

My MSN: mascotzhuang@hotmail.com

🙂