topic Re: GetCurrentField use in cyclic group in QlikView

GetCurrentField use in cyclic group

Tue, 21 Jan 2014 20:17:26 GMT

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!

Re: GetCurrentField use in cyclic group

Anonymous — Tue, 21 Jan 2014 20:21:15 GMT

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..

Re: GetCurrentField use in cyclic group

iktrayanov — Tue, 21 Jan 2014 20:23:09 GMT

Try to use dollar sign expression.

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

Re: GetCurrentField use in cyclic group

Nicole-Smith — Tue, 21 Jan 2014 20:23:57 GMT

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

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

Then your expression should be:

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

Re: GetCurrentField use in cyclic group

Clever_Anjos — Tue, 21 Jan 2014 20:25:40 GMT

Try to use

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

Re: GetCurrentField use in cyclic group

Anonymous — Tue, 21 Jan 2014 20:32:59 GMT

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

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

Re: GetCurrentField use in cyclic group

Thu, 18 Dec 2014 09:10:51 GMT

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.

Re: GetCurrentField use in cyclic group

chrissurguine — Mon, 15 Jun 2015 15:49:39 GMT

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])