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

[neena123]

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

[#2]

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

[#3]

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

AJ

[rwunderlich · Accepted solution]

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

[neena123]

Loved the idea!! Thanks so much!