1 Reply Latest reply: Dec 17, 2012 4:37 PM by Henric Cronström RSS

    Efficiency of variables vs repeating expressions

    Steve Taschereau

      Noob question here...

       

      If I have multiple sheets/charts that use a common expression, is it more efficient to assign that expression to a variable and then reference the variable in the various sheets/charts than to have the expression repeated over and over in each object?

       

      For example if I need to plot:

       

      sum(bad_call)/sum(call_count)  vs sum(good_call)/sum(call_count)

       

      would it be better to create vCallCount =sum(call_count) and then plot

       

      sum(bad_call)/vCallCount vs sum(good_call)/vCallCount.     

       

      Or is QlikView smart enough to recognize multiple instances of sum(call_count) and calculate it once?

       

      Thanks,

      Steve