topic How to Add Buttons on Tables in QlikView

How to Add Buttons on Tables

Wed, 14 Dec 2011 18:55:17 GMT

Hello All!!

Does any knows a way to add buttons in a table?

What i need its to add buttons to launch some .bat archives to run processes.

If any can help me, please, let me know.

Thanks!

How to Add Buttons on Tables

jagan — Thu, 15 Dec 2011 05:53:55 GMT

Hi,

Your question is not clear, do you want to add buttons on the sheet or table?

If you want to add buttons on the sheet just follow the below steps

-Click Right mouse

-Select New sheet Object -> Button -> Give Caption

-Go to Button properties -> Actions Tab -> Launch and give file path to launch.

If you want to place the button above Straight/Pivot table, select Button Properties -> Layout -> Layer -> Top.

Hope this helps you.

Regards,

Jagan.

How to Add Buttons on Tables

Fri, 16 Dec 2011 18:43:01 GMT

Thanks Jagan for your answer. but let me explain better my needs.

Lets suposse that you have a table or a pivot table.

On each cell of the pivot table, you have certain value. ok?

Lets suppose that if the value its ´OK´ would be nice to have a button on a side of this value to launch an action.

Im thinking on a Status table where i check the final status of my processes and, if they where not ok, use the button on a side to each process to launch it again.

It is a better explanation??

Regards!

How to Add Buttons on Tables

Sun, 18 Dec 2011 14:05:58 GMT

Hi there, there isn't a way to add actions to values in a table yet, but I have used a workaround before in a straight table, you may be able to modify it for a pivot table, maybe with dummy dimension that is a concatenation of the others?

You can attach actions to changes in field selections, and you can select a field if it is a dimension. So in my table I created a fake "repeat" dimension and made it look as plain as possible.

I then changed the second column to be just a colour, with border by changing the background and text colour in the dimension to green:

I then went into the document properties, and and under the field event triggers added an action for 'PCT Code' to launch a macro. the subsequent action was the action "back" which would "undo" the selection.

NB you may have to add back several times, depending on the number of actions you have done. if you are changing variables etc that would reverse what you have done but it sounds like you are launching a macro so you should be okay.

Erica

How to Add Buttons on Tables

Sun, 18 Dec 2011 14:22:09 GMT

Actualyl I've just realised that you can work around this in a better way. Add an expression that looks like a button, eg a traffic light.

when you click on this icon, or any value in the chart Qlikview will make selections in the fields in the pivot table that correspond to it. You can then add actions in one of the fields to a) check that the other field is selected, b) then do an action c) go back a couple of steps so it looks like nothing has changed.

Erica

How to Add Buttons on Tables

rwunderlich — Sun, 18 Dec 2011 18:41:46 GMT

If your action can be lauched with a URL, using the URL Expression representation in a table can be a good approach.

-Rob

How to Add Buttons on Tables

Mon, 19 Dec 2011 19:52:55 GMT

Sounds like you're reading logs to know which .bat failed -- do you want to re-launch one at a time, or do you need to launch more than one?

If more than one, does it matter which order they run in?

If you do relaunch something, how do you plan to get an update on status? Reload the QVW?

How to Add Buttons on Tables

Thu, 22 Dec 2011 14:19:41 GMT

Im sorry Erica. It seems that your answer its very helpfull but... i dont understand it in the perfect way to be implemented.

Thanks for all anyway.

Regards

Re: How to Add Buttons on Tables

emteam162 — Mon, 08 Oct 2012 16:04:06 GMT

Hi Erica,

I have same problem

Please, can you attach QV application an example.

Best Regards,

Emteam

Re: How to Add Buttons on Tables

emteam162 — Mon, 08 Oct 2012 16:13:05 GMT

Hi Erica,

I have same issue

Please, can you attach QV an example.

Best Regards,

Emteam

Re: How to Add Buttons on Tables

Wed, 10 Oct 2012 20:33:59 GMT

Hi Emteam162 and others!

Please see attached example. Clicking on the "buttons" for Wales and anglesey runs 1 macro, if you click on the others it runs another.

Table and macros are based on fake "selections" in a field in the dimension of the table.

Erica

Re: How to Add Buttons on Tables

Tue, 19 Aug 2014 22:18:04 GMT

Hi Erica, very ellegant your sollution, i hope it works for me. Thank you!