topic Re: Shared Cyclic Groups in QlikView

Shared Cyclic Groups

mirasifali — Thu, 02 Apr 2015 08:53:35 GMT

Hi Guys,

Is it possible to have a common cyclic group controlling more than one charts. I have a UI reqiurement in which , client wants to show only one cyclic group simultanoeusly controlling two charts. Is this possible ??

Help Appreciated.

Thanks,

Asif.

Re: Shared Cyclic Groups

Gysbert_Wassenaar — Fri, 03 Apr 2015 13:08:58 GMT

Cyclic (and drill down) groups are defined at the document level. You only have to define a group once to be able to use it in any chart you want.

Re: Shared Cyclic Groups

vikasmahajan — Fri, 03 Apr 2015 13:19:41 GMT

You can define Cyclic Groups and can use across the charts so that when you change values in one chart other chart also change accordingly.

For eg Create Cyclic Grp : LOCDEPT which may contain location and dept dimension use this in one chart same group use in chart 2 .

Hope this may help you.

Vikas

Re: Shared Cyclic Groups

oknotsen — Fri, 03 Apr 2015 14:00:01 GMT

Groups are defined at document level.

If you change the choice in 1 group, all other charts that are using the same group will also change their dimension.

The button will show on all charts, but act as 1.

Re: Shared Cyclic Groups

mirasifali — Tue, 14 Apr 2015 15:29:20 GMT

Thanks every one for your reply. But I am taking about the Expressions group and not the dimension group.I am aware that we can group the dimension and have different charts respond to the same group. But in my case I have Expressions group in two different charts, which I have to share

Re: Shared Cyclic Groups

stigchel — Tue, 14 Apr 2015 15:53:15 GMT

Maybe you can do something with the suggestion of John here:

How to get the used expression?

Re: Shared Cyclic Groups

oknotsen — Tue, 14 Apr 2015 15:58:45 GMT

Consider putting the expressions into variables (in script or an include file) and use those.

Example script:

SET vCalculation = sum(Sales);

Example expression:

=$(vCalculation)

This way you can maintain your expressions at one central location and re-use them by means of variable.