0 Replies Latest reply: Oct 17, 2018 3:50 PM by Alan Walker RSS

    In Qlik Sense, how to create a measure with conditions?

    Alan Walker

      Hi,

       

      I am new to Qlik Sense and have trouble creating calculated fields.

      My data only contains two columns, and I want to create a third column for future sales by Amount*Probabilty:

       

      AmountStage
      4316Explore
      1522Begin
      3081Middle
      1566Middle
      4600Develop
      1171Product
      5123Sell

       

      Conversion probability

      Explore = 0.1

      Begin=0.2

      Middle=0.3

      Develop=0.4

      Product=0.8

      Sell=0.1

       

      For example, the future sales for the first row would be 4316*0.1=431.6

       

      Can anyone help me with this problem? Thanks in advance.