Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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



2 Replies
Oleg_Troyansky
MVP & Luminary
MVP & Luminary

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

Not applicable

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 '