topic Re: GetCurrentField() as variable in QlikView

GetCurrentField() as variable

Tue, 23 Aug 2016 15:36:00 GMT

Hello,

I'm trying to put an expression into a variable, but I encounter problems with one specific expression.

The expression is:

IF(GETPOSSIBLECOUNT($(=GETCURRENTFIELD(GROUPFIELD)))>4,1,0)

This expression works this way when I use it literally in the expression box. But when I try to put in a variable in the script, I don't get a result. The problem is in the GETCURRENTFIELD() - when I type instead one of the possible fields, the expression is working.

Is there any solution for this? Or do I just have to use the expression instead of a variable for this calculation?

Re: GetCurrentField() as variable

sunny_talwar — Tue, 23 Aug 2016 15:39:34 GMT

May be trigger the value of GetCurrentField into a varialble and use the variable instead of the function itself

Re: GetCurrentField() as variable

Anonymous — Tue, 23 Aug 2016 16:02:31 GMT

I have checked, its working fine...

Re: GetCurrentField() as variable

Tue, 23 Aug 2016 16:13:22 GMT

Tried to put the GetCurrentField into a variable, but couldn't use it in a next variable.

But I have found the solution:

SET vCurrentField='If((GetPossibleCount('&GetCurrentField(GROUP)&'))>4,1,0)';

In the expression box, I need to use this variable with the Dollar Sign Expansion:

=$(=$(vCurrentField))

Maybe not the best solution, but it works.

Re: GetCurrentField() as variable

Anonymous — Tue, 23 Aug 2016 21:11:07 GMT

Glad to learn the Field Functions