topic Re: IF(getcurrentfield Not Working in QlikView

IF(getcurrentfield Not Working

alexandergrando — Mon, 26 Jun 2017 23:26:59 GMT

Hi,

I am trying to use the following expression:

If(getcurrentfield(MyGroup)='Properties', 'Hi', 'Bye')

For some reason, the expression only returns 'Bye' even when the current field selected is Properties. Attached is a sample app. Your help would be greatly appreciated. Thanks.

Re: IF(getcurrentfield Not Working

sunny_talwar — Tue, 27 Jun 2017 00:10:56 GMT

You are using the wrong function here.... try like this

If(GetFieldSelections(MyGroup)='Properties', 'Hi', 'Bye')

But if you will only ever make a single selection in your MyGroup field, you can also do

If(MyGroup = 'Properties', 'Hi', 'Bye')

Re: IF(getcurrentfield Not Working

BalaBhaskar_Qlik — Tue, 27 Jun 2017 06:30:19 GMT

GetCurrentField(groupname)

returns the name of the field currently active in the group named groupname.

So better to use GetFieldSelections like: =if(GetFieldSelections(val)=40,'Hi','Bye')

or simple if condition like: =if(val=40,'Hi','Bye')