Association problem

[#1]

Hello QV,

Please find attached excel file and screenshot.

I'm facing selection problem in charts.

When I select an account from the Account listbox it shoud show relevant data in all the cahrts, but it is not happening like that.

Here I have used 'SSO Office' as a key to link Summary and Property tab.

Can any one tell me what would be the possible solution to get relevant data based on filter selection.

Thanks,

Ananth

[jsingh71]

Hi Ananth,

If possible can you please upload a sample qvw so we can look into this, otherwise its not easy to understand the problem.

[jagan]

Hi Ananth,

There is no records for 3m Inc/Gp  (#253878) in By Property sheet, also you need to join both the sheets by Segment, SSO Office and Account or simply Account.  Because Account is the low level data.

Regards,

Jagan.

[#4]

Thanks for your response Jagan,

Sorry, I did not get your point correctly, How can I join two sheets based on 3 columns?

Can you please explain some more clearly.

Thanks,

Ananth

[#5]

Hello JSingh,

I'm facing the association problem in all the tabs, because some fields are available in both the sheets.

How can I overcome this issue please suggest me on this.

Find attached qvw file.

Thanks,

Ananth

[jsingh71]

For me its get filtered based on selection..Plz see below

[#7]

Oh great, how did you do that, please tell me.

What changes have you made

[jsingh71]

Simply first I cleared all the selection and then from account list box I selected 3M INC/GP and its working fine for me.

[#9]

But when you click on clear, then the chart is showing all the values same, that should not happen, it should display relevant account revenue, goal, performance...