topic Cyclic expression, GetCurrentField? in QlikView

Cyclic expression, GetCurrentField?

Wed, 01 Jun 2011 19:01:45 GMT

Is it possible to get the current label from the cyclic expression.

I have a table with 3 columns, in column 1 is use a cyclic expression.

I want column 3 to react (different formula) on the chosen expression from column 1.

is this possible with getcurrentfield (cyclic expression is not a dim-group) or is there a other function to use?

Cyclic expression, GetCurrentField?

Wed, 01 Jun 2011 19:21:47 GMT

Hi Jochem, you can, however is not as ellegant as using the getcurrentfield function with group expression. For instance, let's say you have a group of expression that contain a expression labeled as One and another expression labeled as Two, then in you third expression which is not part of the group, you could use something like:

=if(len([One]),sum(1),if(len([Two]),sum(2)))

Regards

Cyclic expression, GetCurrentField?

Wed, 01 Jun 2011 21:34:17 GMT

Thanx Ivan, thats the solution!