GetCurrentField use in cyclic group

[#1]

I'm trying to use GetCurrentField() to individualize the expression for each field in the cyclic group, but it doesnt seem to be working. My whole expression is currently:

=count({<GetCurrentField(group_name)={'<NULL>'}>} [field])

The expression editor says the expression above has an error. However, if I take out the surrounding text and just have "=GetCurrentField(group_name)", the expression returns the name of the field. Also, if I just substitute the cyclic group field into the location of the function GetCurrentField(), qlikview also returns the correct result.

I'd appreciate any help as to why it doesn't work when I combine the two expressions. Thanks!

[Anonymous]

Stephen,

In set analysis, it is allowed to use only explicit field names, no expressions here

=count({<FieldNameHere={whatever}>} [field])

Edit: it makes sense to try with variables though..

[iktrayanov]

Try to use dollar sign expression.

=count({<$(GetCurrentField(group_name))={'<NULL>'}>} [field])

[Nicole-Smith · Accepted solution]

Create a variable (let's say vGroup) and define it as:

='[' & GetCurrentField(group_name) & ']'

Then your expression should be:

=count({<$(vGroup)={'<NULL>'}>} [field])

[Clever_Anjos]

Try to use

sum({<$(=GetCurrentField(GH))={'A'}>}Expression1)

[Anonymous]

Yes, it does work, to my surprise.  I had to add [] because some fields had spaces:

sum({<[$(=GetCurrentField(GH))]={'A'}>}Expression1)

[#7]

I have a question to you..

If I declare a Group name like '>>Group1' or '<<Group' is it possible to write expression with that Name?

Please let me know.

Thanks you all.

[chrissurguine]

Hate to bump an old thread, but in the interest of those who use this solution, this didn't work for me, and I had to change it. The ampersands seem to mess things up in the final set analysis expression.

='[GetCurrentField(group_name)]'

Final expression is the same as Nicole's original:

=count({<$(vGroup)={'<NULL>'}>} [field])