Dynamic display of charts

[montubhardwaj]

HI all,

Hope you are doing all well. I have little complex requirements which I am trying to achieve since some time. Here is the description:

I have three charts says chart1, chart2 and chart3. All of these charts are showing measure as 'Good,bad or ugly based on the dimension it is using.

At a time in the sheet, only two of these charts will be shown and they should be dynamic. By dynamic I meant the top two charts which has high % of "Good" should be shown by default all the time. If we make some selection, that should affect these charts as well and again only the two charts with highest "Good" % should be shown i.e. charts should minimize/maximize if there is any change in the Good %.

Attached is the sample Qvw for your reference. I am using QV9.

Thanking you in advance and hoping for your ideas [:)]

[montubhardwaj]

Anyone got to say something on this???

[#3]

Hi,

You may need to do, something like attached application.

-Sridhar

[montubhardwaj]

HISridhar... thanks for looking into it. But I dint quite get it and was confusing me would you please explain your approach a little ?

Also, the charts should be dynamic. If any selection changes the value for "Good", the charts should also maximize/minimize accordingly.

[#5]

Hi sharma,

Have a look at this new application and below is my explanation for the attached application.

Scenario 1: When you select "Feb" from month:

Chart 1 --> Good % is 20.63 %

Chart 2 --> Good % is 21.58 %

Chart 3 --> Good % is 25.41 %

So the top 2 percentage of good is been displayed in application i.e. chart 2 and chart 3 is displayed.

Scenario 2: When you select "Jan" from month:

Chart 1 --> Good % is 35.02 %

Chart 2 --> Good % is 37.57 %

Chart 3 --> Good % is 25.89 %

So the top 2 percentage of good is been displayed in application i.e. chart 1 and chart 2 is displayed.

i have used the aggr() function to calculate the percentage for each graph and compare the calculated expression in

Chart Property. To see the expression "Right Click on Chart--> Property--> Layout--> Conditional--> look for expression here".

Hope this clarifies your doubt.

- Sridhar

[#6]

Hi Sharma,

Kindly verify the attached application,

in this application i am declaring variable as for u r requirement..

Regards,

Sampath Kumar . G

[montubhardwaj]

Hi Sridhar.... Thank you for looking into it. Your approach is fine but this will hide the other charts objects. For example, if you select Month as Jan, you will see only chart 1 and chart2. Chart3 will be hidden. I want the rest of the charts(which are not among top 2 ) to be minimized so that users can open it frm there if they want.

@Sampath: Thanks for your interest buddy but this is not I want. Please see the attached from Sridhar and then you ll know the exact requirement.