possible to create table with mouse-over using extension?

[#1]

Hi All,

my client has a request to show extra information on a value when users moue-over on the value.

is this achievable with extension ?

thanks a lot.

[#2]

Yes and no. As extension objects give you a place to render custom visulizations, yes. These custom visualizations can include mouse over popups. But what you can not do (today) with extension objects is alter an exesting object's behavior. In other words, you can replace the chart, but not add to or customize the chart.

[rwunderlich]

What do you mean by "extra information"? Standard Charts do allow for extra expressions to be specified that will display additional text information in the hover popup. You can get quite creative. Could you be more specific about what you want to add?

-Rob

http://robwunderlich.com

[#4]

Thanks Rob. I look through your cookbook and found the pop-up solution.

What I need to achieve is to show text information on a particular value in a cell in a table.

For e.g. State is the dimension placed as column in a table, Measures are placed as row.

For each measure for a state, users want to click on the cell and it'll show the drill-in chart for that State and Measure. Certain measure has mixed values for e.g. 100 / 20, 100 is for MTD while 20 is for today. So they want a pop-up to inform users that first value is MTD while 2nd value is for today.

From your cookbook, I can use transparent textbox Help Text and add trigger to open another qlikview document to show the drill-in chart.

Is there other way where I can achieve the pop-up and link to open drill-in chart?

Cos I'll need to create quite a lot of textboxes i.e. number of State * number of Measures.

Maintenance can be quite tedious as users may want to add Measures in the middle of the table in the future.

Thanks so much!

[rwunderlich]

A simple way to handle the detail chart is to only show the detail chart when getPossibleCount(State)=1. See attached for an example.

Table charts unfortunately don't provide cell popups. Let me think that one over and see if I can find a suggestion.

-Rob

http://robwunderlich.com

[#6]

Thanks a lot, Rob.

But they user doesn't want the dashboard to be filtered. The dashboard items should be the same. Values will only change due to user's date input.

Client is a semicon manufacturing company. There are many fabs and one of the them did the dashboard in .Net which provides drill-in and mouse-over functionality. So other fabs want to follow and they expect Qlikview to be able to do the same and more.

[rwunderlich]

What you are describing is commonly called "micro-charts". I've done it in the past with macros but it's a pain. The basic flow is this.

1. Set an OnSelect for some dimension to fire a macro.

2. In the macro:

a. Make the micro chart visible by setting a variable used in the micro chart Show Condtion.

b. Detach the micro chart.

c. Call ActiveDocument.Back to "undo" the selection.

Provide a button to close (toggle the visibility var) the micro chart, or try to rely on an object deactive event to do this.

It's not a hover popup. it requires a click.

-Rob

http://robwunderlich.com

[nagaiank]

Do you havedetails of extensions implementing mouse-over popups?

Qlikview actions require a click. Is it possible to implement actions on mouse-over?

Thank you in advance for your input / help.

[feliciano_alan]

This solution is very functional.

Pop up text for a straight table column