topic Reflect the changes in duplicated chart in QlikView

Reflect the changes in duplicated chart

Wed, 11 Aug 2010 10:29:58 GMT

Hi,

I've a created a chart with cyclic groups in X-axis and Y-axis, so I could change my dimensions & measures. Then I've copied the same chart and pasted below (Replica of the 1st chart).

When I change the dimension (x-axis) in any of the chart its reflecting in both the charts. But its not changing for the mesures (y-axis).

I want to create a way in that if I change dimension/measure, it should reflect in both the charts. Find the attachment.

Please let me know how to do it?

Reflect the changes in duplicated chart

Anonymous — Wed, 11 Aug 2010 10:36:10 GMT

The dimension group is document wide and a change in one place will reflect in other objects. The expression group is object specific and updates in one object will not reflect in others.

If one is tricky enough it might be possible to make a decent solution using a macro with the CycleExpPos member but it's probably gonna get messy to sort out.

Reflect the changes in duplicated chart

Wed, 11 Aug 2010 10:47:19 GMT

How to capture the "definition" (formula) / "column name" in the expression for the 1st chart? So that I could store it in a variable and use it in the 2nd chart.

Reflect the changes in duplicated chart

Wed, 11 Aug 2010 11:23:03 GMT

Any other tricky method to do it?

Reflect the changes in duplicated chart

Anonymous — Wed, 11 Aug 2010 11:26:47 GMT

Actually I can't think of any since you can't trigger a macro on cycling the expression in an object. Load the expressions in a separate fields to select from and then just call the fieldname as expression in the charts perhaps. No use of expression groups.

Reflect the changes in duplicated chart

Wed, 11 Aug 2010 11:39:27 GMT

No, If I load the expression in a separate field it should appear outside the chart. But i want everthing should appear as a cyclic group.

My requirement is if I modify the expression in the 1st chart, 2nd chart will reflect. (I'll not modify the 2nd chart). What are all the other methods to achieve this?

Reflect the changes in duplicated chart

Wed, 11 Aug 2010 13:47:35 GMT

Is there any method to find out the expression in the chart in Qlikview API?

Reflect the changes in duplicated chart

Wed, 11 Aug 2010 15:07:31 GMT

The easiest way I can think of is to create an indicator use that in your expression, instead of the y-axis cyclic group in both the charts. Please refer to the attach example.