topic Using field names from variables. in QlikView

Using field names from variables.

Anonymous — Mon, 16 Jul 2018 13:42:11 GMT

I have 2 formulas:

vNumeratorField = '[' & Only({1} NumeratorNames) & ']'

vDenominatorFiels= '[' & Only({1} DenominatorNames) & ']'

I need them, to find out which fields, I have to use in order to calculate the defined ratio. The typical output is following:

KPI_Name	Numerator Field Name	Denominator Field Name	Min	Header 5
Ratio1	=$(vNumeratorField)	=$(vDenominatorField)

I am trying to find out the minimum and the maximum values doing the following for minimum:

=Min($(=$(vNumeratorField))/$(=$(vDenominatorField)))

And the same logic for maximum, but I always get '-'.

I tried to do the minimum without variables and it works perfectly: Min([FIELD1]/[FIELD2]).

Can someone advice, what should be done in other way? The issue is that I need to always ignore selections on NumeratorNames and DenominatorNames fields. That's why I am using variables and Only()

Re: Using field names from variables.

YoussefBelloum — Mon, 16 Jul 2018 13:50:33 GMT

Hi,

try this:

Min( {<NumeratorNames,DenominatorNames>} [FIELD1]/[FIELD2])

Re: Using field names from variables.

ogautier62 — Mon, 16 Jul 2018 13:56:43 GMT

Hi,

you surely have a nested agregation (because of only)

try with :

min (aggr($(vNumeratorField)/$(vDenominatorField), your dimension))

regards

Re: Using field names from variables.

Anonymous — Mon, 16 Jul 2018 14:07:36 GMT

Thanks for the suggestion, but it doesn't do the trick (

Re: Using field names from variables.

ogautier62 — Mon, 16 Jul 2018 14:16:28 GMT

that gives what ?

null ?

to select all

min({1}aggr( .......)

Re: Using field names from variables.

Anonymous — Mon, 16 Jul 2018 14:36:05 GMT

The output is always '-' and same applies to min({1} aggr(....)). When I try to use:

=Aggr($(vNumeratorField)/$(vDenominatorField),KPI_Name),

then I see the names for the right fields, but the division '/' sign gets dissapeared and the selection is, obviously, not ignored.

Re: Using field names from variables.

ogautier62 — Mon, 16 Jul 2018 15:11:04 GMT

aggr does not pally to kpi_name but :

min (aggr(only({1} NumeratorField,NumeratorField)) / ......

it becomes complicated,

why not :

min({1} NumeratorField/NumeratorField))

without using only ?