topic Re: Using the GetFieldSelections() in QlikView

Using the GetFieldSelections()

AmCh — Sat, 10 Apr 2021 17:51:33 GMT

Hello all,

I have as an example:

Field_a

I want to do some calculations based on the value selected in Field_a (as an example GetFieldSelections(Field_a)=y)

let vTest_y=B0_y + B1_y + B2_y;

B0_y, B1_y, B2_y are already loaded as fields.

I want only to catch them based on the selected value and to affect the calculated value into new variable named vTest_y.

Any help please?

Thanks in advance.

Re: Using the GetFieldSelections()

Dalton_Ruer — Tue, 13 Apr 2021 13:14:33 GMT

Logically GetFieldSelections is a function that will return to you the value that is selected for the given field. So if your user manually selected Y, then GetFieldSelections("field_a") would return the value Y.

I think what you may be trying to do is create an expression that pretends that the end user selected the value Y in "field_a". Within Qlik that is called Set Analysis which you can find out more about by clicking here.

However, I'm not really sure what you are trying to accomplish.

Re: Using the GetFieldSelections()

AmCh — Tue, 13 Apr 2021 14:39:02 GMT

Thank you for your reply.

set analysis cannot help me in this case, because field_a is not associated to other fields (e.g. B0, B1 and B2).

Based on the selected value of field_a (for example y), I want to call the fields B0_y,B1_y and B2_y, which are already imported and named like that. I want only to catch them, and with them to define a new variable named vTest_y.

In other words: I want to use values of field_a only to catch and to name.