4 Replies Latest reply: Feb 1, 2017 11:41 PM by Haikuo Yu RSS

    Is it possible to use Max and Sum together in Qlik sense expression

    Haikuo Yu

      I have an expression as: Sum(my_value)/my_area to calculate the recording per area.

      I would like to normalize the above to 0 - 1. However, the following does not work.

      (Sum(my_value)/my_area) / max(Sum(my_value)/my_area)

      The issue comes from Max(Sum(my_value)/my_area).

      How could I use Max and Sum in the same expression?

      How could I normalize Sum(my_value)/my_area to 0 -1 ?

      Any suggestion is appreciated!