topic Re: Group Ciclyc Dimension in QlikView

Group Ciclyc Dimension

inigoelv — Tue, 16 Jul 2013 20:04:42 GMT

Hi;

I have a chart with two dimensions, one of them is a temporal ciclyc and the other is other field called Class with the several values fixed: A, B and C

I would like to do a Group Cyclic with the field Class that shows A,B,C or all of them.

Is it possible?

Best regards,

Re: Group Ciclyc Dimension

Tue, 16 Jul 2013 20:42:01 GMT

Can you please post your document?

Re: Group Ciclyc Dimension

luciancotea — Tue, 16 Jul 2013 20:44:44 GMT

Create a new cyclic group, add the Class field, then add a field to the group using expression where you write ='GLOBAL'. While having this new field in group selected, set the label to 'GLOBAL'.

Press OK to return to Chart Dimensions tab where you replace Class dimension with your new created group.

Re: Group Ciclyc Dimension

inigoelv — Tue, 16 Jul 2013 21:47:01 GMT

Thanks Lucian,

it works, but what is the expression in the clycic group for represent too, A, B, C.

I would like to have Global, A, B, C in the ciclic group.

Thanks in advance

Re: Group Ciclyc Dimension

luciancotea — Wed, 17 Jul 2013 05:20:22 GMT

Add to the cyclic group =if (Class='A', Class) with label 'A'

Same for B and C.