topic Re: Cyclical Dimension. Change Cyclical among two charts in QlikView

Cyclical Dimension. Change Cyclical among two charts

Fri, 02 Dec 2011 13:33:47 GMT

Hello everybody,

I have 2 charts, each one usind the same Cyclical Dimension.

My trouble is, when i´ll choose the dimension on first chart, i need choose too the same dimension on second chart, automatically.

Thank you

Cyclical Dimension. Change Cyclical among two charts

erichshiino — Fri, 02 Dec 2011 13:54:13 GMT

Hi,

This should be the standard behavior. You add the same group in two charts and when you cycle the dimension it should be updated in all the objects.

If you want to stop this, you need to create the same group with a different name and add it to the objects.

If this is not your case, can you post an application here with your problem?

Regards,

Erich

Cyclical Dimension. Change Cyclical among two charts

jagan — Fri, 02 Dec 2011 13:56:32 GMT

Hi,

If you change the dimension of Cyclic group in one chart, then the dimension of cyclic group in second chart will automatically change. It is by default in qlikview.

Regards,

Jagan.

Cyclical Dimension. Change Cyclical among two charts

Fri, 02 Dec 2011 14:22:46 GMT

ok, thanks

But how can i use a group as an expression?

Cyclical Dimension. Change Cyclical among two charts

jagan — Fri, 02 Dec 2011 14:28:40 GMT

Hi,

Not clear what you required.

But if you want to group the expreesion do the following

In expression tab of Chart properties, Create the expressions and click on the Group button below, this will group the expressions.

Regards,

jagan.

Cyclical Dimension. Change Cyclical among two charts

Fri, 02 Dec 2011 14:34:22 GMT

Ok,

It´s clear for me... but i need to name this expression...

is it possible?

Re: Cyclical Dimension. Change Cyclical among two charts

johnw — Fri, 02 Dec 2011 21:14:24 GMT

It is not possible to name expression groups. You could create a cyclic group with field names for each expression, and use a pick(match()) to select the correct expression. See attached example. It doesn't use pick(match()) because the expression in this case doesn't require it, but the code is there in a comment to demonstrate the idea.

Re: Cyclical Dimension. Change Cyclical among two charts

Fri, 02 Dec 2011 21:24:42 GMT

Hello John,

It´s works very well.

Thank you so much

Joao

Re: Cyclical Dimension. Change Cyclical among two charts

Wed, 13 Nov 2013 05:59:22 GMT

Hi John,

I can't access the qvw, as I'm using personal edition.

Could you please explain the procedure in-detail, to get the requirement.

Thanks in Advance.

Regards,

Pavan.