topic Reg: Expression cyclic group in Pivot table / St table : in QlikView

Reg: Expression cyclic group in Pivot table / St table :

Tue, 21 Apr 2009 18:18:35 GMT

Dear all

In Chart Properties under Expressions tabs there is an option for greating cyclic group for expressions.

Im using a Group which has three expressions reg.

1.Profit

2.Cost

3.Revenue

as labels.

but i want to use only 2 labels(members) like

1.Profit

2.Cost/Revenue

in cyclic.

If we click Profit in cyclic only profit exp should come.

If we click Cost/Revenue in clyclic two expressions for Cost and Revenue should come.

can any one tell me how to use cyclic here.

Regards

Ashok Kumar

Reg: Expression cyclic group in Pivot table / St table :

Oleg_Troyansky — Tue, 21 Apr 2009 20:53:45 GMT

Ashok,

Cyclic groups only allow single expressions (very much like cyclic dimension groups only allow single dimensions). It looks like in your case you need two similar charts, one with a single expression and another one with two expressions.

hope it helps,

Oleg

Reg: Expression cyclic group in Pivot table / St table :

Fri, 13 Nov 2009 19:39:10 GMT

I ran into the same problem.

My solution was to use an if expression based on a variable in the title, label and expression entries.
Also I used a button to switch the status of the variable (here it is named my_cyclic) between wanted states.

For instance:

The button action used is set to change the variable my_cyclic as follows: (so my_cyclic is always either 0 or 1)


=mod(my_cyclic+1,2) // my_cyclic swaps between 2 expressions, increase the number 2 to increase the size of your cyclic group.

Expression:


=if(
 my_cyclic=0, sum(field1),
 if(my_cyclic=1, sum(field2_a*field2_b))
)

title:


=if(my_cyclic=0,'Title 1',
 if(my_cyclic=1,'Title 2')
)
&' using the my_cyclic variable '