Opening a Sheet based on the click of a selected chart in an other Sheet

[#1]

Hi,

     I have a couple of Questions over here.

     The first one is I need to open a sheet based on the click of a bar in some other chart.Please let me know how to acheive this?

      The second one is: Suppose we have some data in a table 

        Column A    Column B       Column C

           A                  1                   @

           A                   2                   %

           A                    3                  (

           B                   4                    *

           C                   5                     &

        Now  A is present three times,but I have to show it only one single time. Something like

          A              1         @

                           2         %

                           3          (

        I have no Expressions here.

        Please let me know the way forward.

   Regards

   Navin Gorapalli     

[kaushiknsolanki]

Hi,

   I appreciate the work done by Neetu, but the problem is if the no of bar will increase that solution will not work.

   So here is my solution.

Regards,

Kaushik Solanki

[neetu_singh]

Hi Kaushik,

I appreciate and i think this will resolve Navin's issue.

Thanks for correcting me.

Regards

Neetu Singh   

[#4]

Hey Kaushik,

                    I need to capture the expression.Here,you have a single expression but in my application I have

   four expressions and a  single dimension.I  need to detect which bar has been clcked upon.

Regards

Navin Gorapalli

[kaushiknsolanki]

Hi,

   Till i know its not possible to have any actions on expressions.

   I dont think that its possible with macro too, but i will give a try and let you know if i crack this.

Regards,

Kaushik Solanki

[qliksus]

Can u  name the expression in the script and take that as dimension and based on that selection

go to the respective sheet .See the attached file and let me know this is what you are looking for

here  your original dimension can be taken in the list box .

[#7]

Hi qliksus,

   Sorry for not replying to you these many days

      What does Resident V mean here?

    I have a Sql data source here..Is this possible with sql data source??

load empid,

'nm' as tst,

count(name) as nm

Resident v

Group By empid;

What if I have a If Loop in my Expression or may be a Set analysis Expression???

But I think this will maybe solve my problem.

Please let me know

Regards

Navin Gorapalli