topic Can I create a button in a straight table that once clicked upon sends the user to another sheet? in QlikView

Can I create a button in a straight table that once clicked upon sends the user to another sheet?

neena123 — Wed, 19 Feb 2014 20:57:59 GMT

I would like to create a button for a column in a straight table.

For example:

company Ship 3+ Days

A 10

B 5

C 0

D 29

E 3

F 66

I would like to be able to click on any number that is larger than 5 and take me to a new sheet to show what are those exact orders are, where are they, when did the company get the order in etc....

Re: Can I create a button in a straight table that once clicked upon sends the user to another sheet?

Wed, 19 Feb 2014 21:25:06 GMT

Hi neena,

as charts do not have triggers, I suggest to use a workaround. See attached example. I used two text objects (which I prefer against buttons) to give you an idea. Or you can put the (transparent) textobject in front of the baccording chartcolumn: Make it available only when max() >0 5.

HtH
Roland

Re: Can I create a button in a straight table that once clicked upon sends the user to another sheet?

Wed, 19 Feb 2014 21:35:58 GMT

Hey Neena,

Triggers can't be created in charts. Its possible only in three objects.

Button
Text object
Line/Arrow

As suggested by Roland you can superimpose one of these objects on top of the chart to get the expected result.

I dont see the point as to why it should be in the chart itself. Per your example if there are orders with metrics greater than 5 then create a table with all the details for those specific orders and when you click the button it should take you to that chart.

Hope it helps

Thanks

Re: Can I create a button in a straight table that once clicked upon sends the user to another sheet?

rwunderlich — Wed, 19 Feb 2014 23:09:56 GMT

It'a not a button, but take a look at this example

http://qlikviewcookbook.com/recipes/download-info/conditional-show-of-details/

I think it fits with what you're after.

-Rob

Re: Can I create a button in a straight table that once clicked upon sends the user to another sheet?

neena123 — Thu, 20 Feb 2014 15:29:09 GMT

Loved the idea!! Thanks so much!