topic Adding action on Bar Chart in QlikView

Adding action on Bar Chart

Fri, 27 Jun 2014 06:06:10 GMT

Hello,

I am new to Qlikview. I am developing an application where I am displaying data in bar chart. My requirement is to add an action to the Bar chart so that If user cliks on the chart he is redirected to another sheet. here is screen shot of my chart..

My aim is not add an extra button or text box on the chart but to add an action which redirects the user to another sheet.

Thanks for your help in advance.

Re: Adding action on Bar Chart

Fri, 27 Jun 2014 06:10:16 GMT

create a text box with the same dimensions as the graph. Set the transparency to 100%

Set an action for the text box.

Re: Adding action on Bar Chart

amit_saini — Fri, 27 Jun 2014 06:13:19 GMT

Hi Prasenjit,

See the attachment and click on "Details" button on bar chart.

Thanks,

Re: Adding action on Bar Chart

sasikanth — Fri, 27 Jun 2014 06:19:35 GMT

Here we cannot set an action to Barchart,

You can create one text box with the same length and then Give an action to that text object

Make sure that

Trasperancy of the text box is 100%

In Layout tab-->layer should be "Top"

later if you want to do any changes in chart then you can do it by making layer as Bottom

Re: Adding action on Bar Chart

Fri, 27 Jun 2014 06:40:59 GMT

hi,

On bar chart there is no such option for action to be set.

so what you can do it.

you can use either text box or button of same size of your chart and make it transparent by transparency setting that is there for it to 100%

and set to top layer else it will go back

and set action on it.

by this you can set action on chart that will be there on button or text box that will not be seen as it will be transparent

Sudhanshu Shrivas

Re: Adding action on Bar Chart

Fri, 27 Jun 2014 06:55:59 GMT

Thanks for your help. But i was not looking to add a text object but an action on the bar chart itself. Thanks again..

Re: Adding action on Bar Chart

amit_saini — Fri, 27 Jun 2014 06:58:35 GMT

Prasenjit,

I don't think so you can do this with bar chart alone.

Thanks,

Re: Adding action on Bar Chart

Fri, 27 Jun 2014 10:05:59 GMT

Thankss

Re: Adding action on Bar Chart

Fri, 26 Jun 2015 13:52:18 GMT

Hi Prasenjit Dewan,

Have you got solution for it , if yes can you please let me know how to do that, now I am faceing the same problem that your described above.

Regards

John

Re: Adding action on Bar Chart

ankit777 — Fri, 26 Jun 2015 13:59:04 GMT

Hi,

U can try a work around. On the dimension of the chart, put a trigger, on any select, navigate to other sheet.

Re: Adding action on Bar Chart

Fri, 26 Jun 2015 14:00:48 GMT

Thanks Ankit Mishra

will it not impact other charts Ankit, for example if I select any filter value, it redirect to other sheet.it should not be like that.

Re: Adding action on Bar Chart

jonas_rezende — Fri, 26 Jun 2015 14:32:03 GMT

Hi.

Set up a trigger for a field an OnSelect event (Settings -> Document Properties -> Triggers).

Perform the following steps :

1. Select fiedl used in dimension;

2. Click button Add Action(s) below OnSelect;

3. Click button Add, Layout choice;

4. Activate Sheet put sheet name;

5. Ok.

Note: Whenever you use the field in this sheet will open another sheet.

Hope this helps!

Re: Adding action on Bar Chart

Fri, 26 Jun 2015 14:38:17 GMT

Thanks Jonas Melo,

I am using a Drilldown group as my dimension, will it work.

Regards

John

Re: Adding action on Bar Chart

ankit777 — Sat, 27 Jun 2015 17:53:11 GMT

It does make an impact, as the value will be selected in the field.

Re: Adding action on Bar Chart

Mon, 08 Feb 2016 23:58:23 GMT

Go to Document properties -> Triggers -> Field Event Triggers -> Select the dimension (e.g Date) -> Click Add Action in On Select Option. In the Action , Select Layout -> Activate Sheet.

This takes to next sheet when user clicks the chart.

Regards,

Priya