topic Re: chart links to another page in QlikView

chart links to another page

aaronnayan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys

I have a pie chart, with 9 expressions (segments)

I want it so, when the user clicks on 1 segment of the chart it will take him to another page.

I know the use of buttons but i want it to activate a sheet when you select the chart segment.

Many thanks guys

Re: chart links to another page

Wed, 24 May 2017 10:04:08 GMT

It is not possible to jump from one sheet to another without the use of buttons in your condition.

The workaround would be to create buttons equal to the size of your bars and set the action accordingly.

Cheers,

Rohan

Re: chart links to another page

Sergey_Shuklin — Wed, 24 May 2017 10:48:38 GMT

Hi, Aaron!

It is possible.

For instance you have a data:

Load * Inline

[task,val

A,10

B,20

C,30];

Load it. Create a circle chart with dimension "task" and expression "=sum(val)". You'll get your navigator 😃

After that go to the trigger menu (Ctrl+Alt+D -> Triggers), find our field "task" in Field Event Triggers and press Edit Action OnSelect. Choose Layout -> Activate Sheet and where is the sheet should be inputed place an expression:

=pick(match(GetFieldSelections(task),'A','B','C'),'SH02','SH03','SH04')

or you can use a simple function IF to determine sheet name depend of GetFiledSelections(task) funcion.

In my case sheets have a name SH01, SH02 you may have a different ones.

That's all! Now, if you done it right you'll be able to move among sheets by clickin on the pie pieces.

Hope you find it usefull!

P.S.: I've added an example and correct some little mistakes in the text.

Re: chart links to another page

aaronnayan — Thu, 25 May 2017 08:49:50 GMT

Hi Sergey

Thankyou it is possible!. How can this be done if you do not have a dimension in the chart?

Re: chart links to another page

Sergey_Shuklin — Thu, 25 May 2017 09:50:14 GMT

Hi, Aaron!

I've tried to make it w/o a dimension and for now I have no result, because nothing is happenin' when user is clickin on expressions (no selections are returned). Maybe later, when my experience will grow I'll find the answer, but for now I can offer only one decision.

Re: chart links to another page

Frank_Hartmann — Thu, 25 May 2017 11:08:06 GMT

this might be helpful:

Re: Pie Chart