# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

## Cyclic expression, GetCurrentField?

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?

1 Solution

Accepted Solutions
Not applicable

## Cyclic expression, GetCurrentField?

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

2 Replies
Not applicable

## Cyclic expression, GetCurrentField?

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

Not applicable

## Cyclic expression, GetCurrentField?

Thanx Ivan, thats the solution!