topic Re: Get field selection expression does not recognize assembled field name in QlikView

Get field selection expression does not recognize assembled field name

femi_owoseni — Sat, 17 Nov 2018 02:21:33 GMT

Hi,

Does any know what the below expression isn't working.

=GetFieldSelections(SubField(mid(GetCurrentSelections('|'),Index(GetCurrentSelections('|'),'|',-1)+1),':',1))

It seems the GetFieldSelections does not recognize the resulting string from SubField(mid(GetCurrentSelections('|'),Index(GetCurrentSelections('|'),'|',-1)+1),':',1) as a valid field name.

I tried appending '[' ']' or Chr(39) but no luck so far.

Thanks in advance

Re: Get field selection expression does not recognize assembled field name

sunny_talwar — Sat, 17 Nov 2018 02:27:56 GMT

May be try this

=GetFieldSelections($(=SubField(mid(GetCurrentSelections('|'), Index(GetCurrentSelections('|'), '|', -1) + 1),':',1)))

Re: Get field selection expression does not recognize assembled field name

femi_owoseni — Sat, 17 Nov 2018 03:35:38 GMT

Hi Stalwar1,

I got an invalid dimension error when I tried it

Re: Get field selection expression does not recognize assembled field name

muthukumar77 — Sat, 17 Nov 2018 11:15:43 GMT

Hi,

1. Create variable:

vGetFielsSelections : =chr(91)&SubField(mid(GetCurrentSelections('|'),Index(GetCurrentSelections('|'),'|',-1)+1),':',1)&chr(93)

2. Call that variable,

=GetFieldSelections($(vGetFielsSelections))

Re: Get field selection expression does not recognize assembled field name

sunny_talwar — Sat, 17 Nov 2018 23:03:58 GMT

May be give this a shot

=GetFieldSelections($(='[' & SubField(mid(GetCurrentSelections('|'), Index(GetCurrentSelections('|'), '|', -1) + 1),':',1) & ']'))

Re: Get field selection expression does not recognize assembled field name

femi_owoseni — Mon, 19 Nov 2018 13:46:40 GMT

Stalwar, Thank you very much. It worked. Can I trouble you to explain the modifications to my expression in particular why I needed to include $(...)

Re: Get field selection expression does not recognize assembled field name

femi_owoseni — Mon, 19 Nov 2018 13:48:18 GMT

Thanks I found a solution. But I will also try yours as well when I get the chance.

Re: Get field selection expression does not recognize assembled field name

sunny_talwar — Mon, 19 Nov 2018 13:54:23 GMT

The inner expression, i.e.

SubField(mid(GetCurrentSelections('|'),Index(GetCurrentSelections('|'),'|',-1)+1),':',1)

Was giving a field name, but it was not read by GetFieldSelections as a field, but just a text. Using the dollar sign expansion, we told QlikView/Qlik Sense to interpret it as a field rather than just a random text. And the reason we needed [] is because you might have a field which had spaces... and QlikView/ Qlik Sense needs [] brackets for fields with spaces.

HTH

Best,
Sunny

Re: Get field selection expression does not recognize assembled field name

femi_owoseni — Mon, 19 Nov 2018 13:55:34 GMT

You are awesome. Thanks for your help.