topic Cyclic groups possibility in QlikView

Cyclic groups possibility

Anonymous — Tue, 30 Jun 2015 13:48:21 GMT

I have a combo chart with 4 expressions

A ->Expr1 i.e sum(A) ---bar chart

B ->Expr2 i.e sum(B) ---bar "

A1 ->Expr3 i.e count(A) -- line "

B1->Expr4 i.e count(B) --line "

so I created a cyclic group for A & B, and another Cyclic group for A1 and B1, so when I select from A from cyclic group1, the chart has to show values of A and A1 i.e sum and count , the same goes when I select B

John

Re: Cyclic groups possibility

rubenmarin — Tue, 30 Jun 2015 13:59:59 GMT

Hi John, I don't know a way to know wich expression is selected in the group, can be donde by macro but changing expression doesn't launch a trigger for the macro.

As a workaround you can create a field with the values the user can select, checking 'allways one value selected' and use conditional expressions based on this field value. I usually use HidePrefix to name those fields used only as slector.

Another way is using buttons to change the value of a variable, and based on that variable make the conditional expression.

Re: Cyclic groups possibility

Anonymous — Tue, 30 Jun 2015 14:14:34 GMT

Thanks Ruben, I know that this can be achieved the way you said but looking for the other way,....

John