topic Re: Association problem in QlikView

Association problem

Tue, 14 Oct 2014 04:59:17 GMT

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

Re: Association problem

jsingh71 — Tue, 14 Oct 2014 05:15:21 GMT

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.

Re: Association problem

jagan — Tue, 14 Oct 2014 05:19:59 GMT

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.

Re: Association problem

Tue, 14 Oct 2014 05:33:02 GMT

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

Re: Re: Association problem

Tue, 14 Oct 2014 05:38:53 GMT

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

Re: Association problem

jsingh71 — Tue, 14 Oct 2014 06:00:23 GMT

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

Re: Association problem

Tue, 14 Oct 2014 06:13:07 GMT

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

What changes have you made

Re: Association problem

jsingh71 — Tue, 14 Oct 2014 06:19:41 GMT

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

Re: Association problem

Tue, 14 Oct 2014 06:25:17 GMT

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...