6 Replies Latest reply: Nov 6, 2018 7:26 AM by Aleksandrs Ivanovs RSS

    calculate correlation using variables Qlik Sense

    Aleksandrs Ivanovs

      Hi!

      I have two variables defined in Qlik Sense variables editor:

      NameDefinition
      vVar1sum(Field1)
      vVar2sum(Field2)/sum(Field3)

       

      I need to create table like this:

      DimensionCorrelation
      Item 10.9
      Item 20.6

       

      How i can calculate correlation?

      For now i am trying in expression editor :

      RangeCorrel($(vVar1),$(vVar2)), but result is "-" for every item.

       

      What is wrong?