3 Replies Latest reply: Apr 15, 2013 7:27 AM by Nuno Faustino RSS

    Cant get a field based on dinamic string

    Nuno Faustino

      I have a cyclic group of fields named A_A2 wich has the following fields:

      Q8_Label

      Q10_Label

      Q11_Label

       

      Now I want to avg the same fields in the expression and tried something like this formula:

       

      =avg(Replace(getcurrentfield(A_Q2),'Label','Value'))

       

      to get

       

      avg(Q8_Value)

      avg(Q10_Value)

      avg(Q11_Value)

       

      whenever cyclic changes.

       

      However this doesn't work because Replace(getcurrentfield(A_Q2),'Label','Value') is always recognized as string. I tried to search for something to force it to be seen as a field but couldn't find it on the formulas or on Qlikcommunity.

       

      Is this even possible? It seems simple enough but I can't make it work.

       

      Any help would be appreciated. Thanks.

      Kind regards,

      Nuno