topic Identifying a Selection in a Cyclic Group in QlikView

Identifying a Selection in a Cyclic Group

Fri, 19 Feb 2010 18:27:37 GMT

Hi all. Thanks so much for your help in the past. I've got another question I can't find the answer to right off.

I've got a cyclic group that switches between two values, Country and Device. I need to know whether the user has selected Country or Device so that I can change something in the expression calculation. How can I tell which selection the user has made?

Thanks,

Scott

Identifying a Selection in a Cyclic Group

Anonymous — Fri, 19 Feb 2010 18:49:00 GMT

I guess you're asking about this:

GetCurrentField( groupname )

Identifying a Selection in a Cyclic Group

Fri, 19 Feb 2010 20:43:01 GMT

Hey Michael,

Thanks for the response. I tried it, but it doesn't work. Here's the expression I tried:

Sum(If((FLAG_VALUE='BYCOUNTRY' And GetCurrentField([Country/Device])='Country'), ALL_VISITS,0))

The cyclic group is called Country/Device and the two values are Country or Device.

Do you see any issues with the syntax?

Thanks,

Scott

Identifying a Selection in a Cyclic Group

Fri, 19 Feb 2010 21:32:22 GMT

I figured it out. I was using the label Country and not the actual field name. Thanks for the help, Michael.

Scott