Getting field name from column and performing calculations

Anonymous — Fri, 13 Jul 2018 08:23:36 GMT

Dear experts,

I have a following table structure:

Ratio	Numerator_Field_Name	Denominator_Field_Name	Formula
Ratio 1	Numerator 1	Denominator 1
Ratio 2	Numerator 3	Denominator5

Numerator_Field_Name and Denominator_Field_Name are the name of the columns, which should be considered, while computing formula. Just to test, I have tried the following formula:

=$('Sum(['& Numerator_Field_Name& '])'),

but the result is always '-'.

Can someone give a hint, how to achieve this? Or is there any better way to do? The formulas are basically - min, max, sum, and fractile.

Thanks.

Re: Getting field name from column and performing calculations

vishsaggi — Fri, 13 Jul 2018 15:09:37 GMT

May be try like:

= $(='Sum(['& Numerator_Field_Name& '])')

topic Getting field name from column and performing calculations in QlikView

Getting field name from column and performing calculations

Re: Getting field name from column and performing calculations