Can values of an expression be made as an hyperlink to another object / chart?

[#1]

Hi,

I have a chart that have 2 expressions - Expression1 and Expression2

If the user clicks on a value on Expression1 I want another chart to be displayed.

This is possible, Can values of an expression be made as an hyperlink to another object / chart?

[IAMDV]

Hi Geetha,

Logically thinking... yes, this is possible. You somehow need to capture the contents of the expression and pass it to variable. And when the variable value is changed, you can show/hide the other chart. I can work an example for you. Do you have the sample chart along with the expressions?

And also request you to give more detailed explanation.

Cheers - DV

[#3]

Hi DV,

I have attached a sample file along with explanation.

[IAMDV]

Hi Geetha,

You can use the conditional show/hide in the chart properties and then use the below expression.

=GetSelectedCount(Year) > 0

But I am not sure if your expression in the chart works when you the selection. Let me know if you need help on that. However, this is what you actually need... attaching the same for you.

Cheers - DV

[IAMDV]

Hi Geetha,

Good morning. Have you got this working? Let me know if you have more questions.

Cheers - DV

[#6]

Hi Deepak,

I just having the same problem and I think about the solution you explain.

How can I capture the expresion that have been selected? As far as I know you can know what dimension is selected but I don't know if you can see at what expresion of a table a user has made click.

Thanks.