topic Re: Use GetFieldsSelection in Aggregations in QlikView

Use GetFieldsSelection in Aggregations

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I would like to achieve the following in QlikView:

I have a list box "Parameter" listing all fields by using $Field. If I select one element from Parameter I would like to get min(), max(),avg() for that field in a text box. I tried something like: =max($(=GetFieldSelections($Field))) . But that does not work.

I just want to replace the literal field name by the selected value. How can this be done?

Thank you

Re: Use GetFieldsSelection in Aggregations

lironbaram — Fri, 05 Jan 2018 08:40:55 GMT

try this

='min: ' & $(='min([' & $Field & '])') & chr(10) &

'max:' & $(='max([' & $Field & '])') & chr(10) &

'avg:' & $(='avg([' & $Field & '])') & chr(10) &

'median:' & $(='median([' & $Field & '])')

Re: Use GetFieldsSelection in Aggregations

tresB — Fri, 05 Jan 2018 08:44:11 GMT

This should work when you select a single field from the listbox $Field. However, if your field name has space in between, you might have to try like:

=Max($(='['&getfieldSelections($Field)&']'))

Re: Use GetFieldsSelection in Aggregations

sergio0592 — Fri, 05 Jan 2018 08:45:39 GMT

Hi,

So it should works if you create a variable V_selected_field

=GetFieldSelections([$Field])

Use this var in the text box with : =max($(V_seleted_field))

Re: Use GetFieldsSelection in Aggregations

qliksus — Fri, 05 Jan 2018 08:50:13 GMT

Just put this in a variable Variable1=GetFieldSelections($Field) and use something like

max($(Variable1))

Re: Use GetFieldsSelection in Aggregations

sasikanth — Fri, 05 Jan 2018 08:52:43 GMT

HI Tobias,

try below expression

=max({<$Field={$(=GetFieldSelections($Field))}>} $(vNew))

where vNew is a variable (vNew=getFieldSelections($(Field))

Re: Use GetFieldsSelection in Aggregations

Anonymous — Fri, 05 Jan 2018 09:43:51 GMT

Unfortunately, that does not work for me. The result is empty.

Re: Use GetFieldsSelection in Aggregations

Anonymous — Fri, 05 Jan 2018 09:46:54 GMT

This appears to work ... almost. If I apply the formula to avg() and max() the result is plausible.

However, for min () it is not. Is there a way to display all values that contribute?

I tried to make a table based on GetFieldSelections() but obviously I have not grabbed the mechanics of referencing right.

Re: Use GetFieldsSelection in Aggregations

Anonymous — Fri, 05 Jan 2018 09:52:07 GMT

OK. I got it now. My Diagram does not show all values for some reason.

so =Max($(='['&getfieldSelections($Field)&']')) solved my problem.

Thank you very much.

Re: Use GetFieldsSelection in Aggregations

Anonymous — Fri, 05 Jan 2018 10:37:58 GMT

Actually, I am still missing something. I get wrong values for min, max, avg.

What I did not mention before is that I have a second selection "ModelName" in a list box. Maybe this has an impact.

I have a line diagram and list box showing the selected values consistently if I select a ModelName and a Field.

But the aggregations do not reflect the values that I see in list box like a higher Max than any value in the selected list.

It appears that Max is also not global: If I deselect all ModelName then I get different values than when selecting one.

Do I have to explicitly filter for Model and how do I do it?

Re: Use GetFieldsSelection in Aggregations

tyagishaila — Fri, 05 Jan 2018 10:53:20 GMT

First, you create a variable for GetFieldSelections($field)

e.g. vGetField

than use aggr function with this variable

e.g. Min($(vGetField))

Hope it will work!

Re: Use GetFieldsSelection in Aggregations

tresB — Fri, 05 Jan 2018 11:03:59 GMT

Try putting set analysis identifier {1} for global output, like :

=Max( {1} $(='['&getfieldSelections($Field)&']'))

Re: Use GetFieldsSelection in Aggregations

Anonymous — Fri, 05 Jan 2018 11:55:18 GMT

OK. I found the issue. Has nothing to do with this aggregation.

There is a date dimension that I use for the diagram as well as for the listbox. I have several values per day so the diagram and the list show only values if there is exactly one value per day otherwise nothing.

I have to figure out how display all values for each day. I think that is worth another thread.

Thank you all for your kind help.