topic How to use an if statement conditional on the value of a cyclic-group? in QlikView

How to use an if statement conditional on the value of a cyclic-group?

Sun, 17 Nov 2013 07:49:52 GMT

Hi,

We created a cyclic group ("Time Cyc") that cycles through time variables - e.g. year-week, year-month, year-qtr.

I'd like to use if functions based on the currently selected value of the cyclic group.

e.g.:

if([Time Cyc]={'year-qtr'}, 1, 0)

but if appears I can't use the cyclic group as I would use any other variable........

can it be done? how?

Many thanks

Sun, 17 Nov 2013 08:26:53 GMT

Hi Al,

You can get the selected field within a cyclic/drilldown group by using the GetCurrentField function:

if(Match(GetCurrentField([Time Cyc]), 'year-qtr'), 1, 0).

Sun, 17 Nov 2013 08:31:42 GMT

Cheers! It works!

Many thanks