Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
aaronnayan
Creator III
Creator III

chart links to another page

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

1 Solution

Accepted Solutions
Sergey_Shuklin
Specialist
Specialist

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.

View solution in original post

5 Replies
Not applicable

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

Sergey_Shuklin
Specialist
Specialist

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.

View solution in original post

aaronnayan
Creator III
Creator III
Author

Hi Sergey

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

Sergey_Shuklin
Specialist
Specialist

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.

Frank_Hartmann
Master II
Master II

this might be helpful:

Re: Pie Chart