4 Replies Latest reply: Oct 13, 2014 3:14 PM by Feo van Koutrik RSS

    Dynamic measure to avoid if-statements

      I have a nested if-statement:

      if([Category]='Events',[Events],

      if([Category]='Delegates',[Delegates],

      [Value]))

       

      Is there a qlikview function to dynamically point to a measure field?

       

      I have seen examples where you can dynamically point to a field based on a variable, however based on the row content I want to select the specific measure field.