topic Re: Synchronized Charts in QlikView

Synchronized Charts

Mon, 26 Aug 2013 20:24:56 GMT

Hi,

I need show two charts (dinamic tables) synchronized.

In Chart 1 I have 3 dimensions (Company, Plant and Account)

In Chart 2 I have the same 3 dimensions and one more dimension (Project).

I need to show dinamically Chart 2 with detailed information for the 4 dimensions according with the dimensions shaw in the Chart 1.

In other words, when I select an Account in Chart 1 I need to show Chart 2 with details from the Projects contained in the Account of Chart 1.

How can I do that?

Thanks.

Anonymous — Mon, 26 Aug 2013 20:30:05 GMT

Andre,

If Accounts and Projects are related in your data model, you don't need to do anything else. This is how QlikView works.

Regards,

Michael

Mon, 26 Aug 2013 20:46:08 GMT

Thanks Michael,

Yes they are in the data model, but there are two data sources (from different databases),

The data source from Chart 1 has total values for the 3 dimensions related.

The data source from Chart 2 has their values for the 4 dimensions .

I need to show distorcions betwen the sum values from Chart 2 (at Projects level) and Chart 1 (at Accounts level).

I would like to show Chart 2 and 1 in the same container and alow to compare the differrences betwen the values.

Thanks again!

MarcoARaymundo — Mon, 26 Aug 2013 20:46:44 GMT

In Chart 2, do so:

In project dimension enable [allow conditional] and in the text box... If(GetFieldSelections(Account)=1, true(), false()).

When select Account anywhere, chart 2 show de column project.

From what I understand, I think that's what you want

Mon, 26 Aug 2013 21:03:35 GMT

I'll try this solution...

Thanks!