topic Get Current Selections for CYC group in QlikView

Get Current Selections for CYC group

Anonymous — Wed, 11 May 2016 22:05:07 GMT

Something is wrong with my format.

I want my expression to be an if statement based on the Dimension from the cyc group.

My expression is as follows:

If(Match(GetCurrentSelections([Date Cyc]), 'Scheduled'),

sum(DailyHours))

The error says "Bad field name." Date Cyc is the name of my Cyclic Group. and Scheduled is the label for the expression in that group.

Any help would be greatly appreciated. Thank you in advance.

Re: Get Current Selections for CYC group

sunny_talwar — Thu, 12 May 2016 02:06:38 GMT

I think you might be looking for GetCurrentField(). GetCurrentSelections() doesn't take any arguments:

If(Match(GetCurrentField([Date Cyc]), 'Scheduled'), Sum(DailyHours))

GetCurrentField ‒ QlikView

Re: Get Current Selections for CYC group

Anonymous — Fri, 13 May 2016 22:37:31 GMT

Thanks for the quick response. It says that the expression is okay, but the red error underline is contradicting that. So there is no data to display in the chart. Do have some syntax wrong?

Re: Get Current Selections for CYC group

sunny_talwar — Sat, 14 May 2016 11:39:15 GMT

Did you try clicking okay to see if the expression is giving you the output you were looking for. I think this is an issue for GetCurrentField() function. Expression editor doesn't recognize it, but it works. You can also try this since you are checking for just one field:

If(GetCurrentField([Date Cyc]) = 'Scheduled', Sum(DailyHours))