How to Add Buttons on Tables

[#1]

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!

[jagan]

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.

[#3]

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!

[#4]

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

[#5]

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

[rwunderlich]

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

-Rob

[#7]

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?

[#8]

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

[emteam162]

Hi Erica,

I have same problem

Please, can you attach QV application an example.

Best Regards,

Emteam

[emteam162]

Hi Erica,

I have same issue

Please, can you attach QV an example.

Best Regards,

Emteam