topic Question about Cycle Expressions Groups in QlikView

Question about Cycle Expressions Groups

Mon, 18 May 2009 17:09:53 GMT

Hi all,

I want to know if there is anyway to change the current expression selected on a cycle expression group in a graph. I tried with CycleExpPos, but i couldnt do anything. Basically i want to change the selected expression from a cycle with a macro. Also will be great to know the label of the expression selected.

Lots of thanks beforehand

Question about Cycle Expressions Groups

Anonymous — Tue, 19 May 2009 20:30:57 GMT

Jacobo,
It is certainly possible to change expression in cycle using macro. I've done it:


private function Jump (s)
 groups=ActiveDocument.GetGroups
 groups(0).Cycle s
end function

Here "s" is the number of steps

Question about Cycle Expressions Groups

Tue, 19 May 2009 21:13:58 GMT

Hi Michael,

First of all thanks for your answer. I've tried what you told me, but it seems that works just for Cycle Groups of Fields, and works fine for that by the way. But what i need is to cycle Groups of Expressions (two or more expressions grouped on the expression's tab of a graph).

Again lots of thanks for your help

Question about Cycle Expressions Groups

Anonymous — Wed, 20 May 2009 00:55:41 GMT

Oh, I misread the question, sorry...
I don't have access to QV now, and very limited access to a computer at all, but will try in a few days, unless somebody else will anwser by that time.

Question about Cycle Expressions Groups

Anonymous — Wed, 27 May 2009 01:32:52 GMT

Jacobo,
I didn't find exactly what you're looking for. I think you should be able to achieve the desired result in a different way, for example like in the attached.