Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

2 Replies
Not applicable
Author

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
Author

Thanx Ivan, thats the solution!