topic AW:Re: How to get Mouse position? in QlikView

How to get Mouse position?

Thu, 13 Aug 2009 15:50:13 GMT

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.

How to get Mouse position?

biester — Mon, 17 Aug 2009 20:50:26 GMT

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

How to get Mouse position?

Tue, 18 Aug 2009 20:19:56 GMT

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

AW:Re: How to get Mouse position?

biester — Wed, 19 Aug 2009 19:43:08 GMT

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

AW:Re: How to get Mouse position?

Thu, 20 Aug 2009 15:18:06 GMT

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.

AW:Re: AW:Re: How to get Mouse position?

biester — Thu, 20 Aug 2009 17:53:53 GMT

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

AW:Re: AW:Re: How to get Mouse position?

Thu, 20 Aug 2009 19:07:02 GMT

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. 😞

AW:Re: AW:Re: AW:Re: How to get Mouse position?

biester — Thu, 20 Aug 2009 20:48:31 GMT

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

AW:Re: AW:Re: AW:Re: How to get Mouse position?

biester — Tue, 25 Aug 2009 03:05:13 GMT

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

AW:Re: AW:Re: AW:Re: How to get Mouse position?

Tue, 25 Aug 2009 07:15:16 GMT

Many thanks......

May I have your IM Account?

My MSN: mascotzhuang@hotmail.com

🙂

AW:Re: AW:Re: AW:Re: How to get Mouse position?

biester — Mon, 28 Sep 2009 19:52:55 GMT

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

AW:Re: AW:Re: AW:Re: How to get Mouse position?

Tue, 29 Sep 2009 12:50:04 GMT

Many Thx......

AW:Re: AW:Re: AW:Re: How to get Mouse position?

Tue, 29 Sep 2009 12:50:07 GMT

Many Thx......