14 Replies Latest reply: Dec 8, 2017 6:50 AM by neha shirsath RSS

    Logic with set of rules

    nareshthavidishetty nareshthavidishetty

      Hi,

       

      We have a logic in qlikiew

       

      Logic:

       

      Sales rate: (Sum(Sales)/Count(TransID))*100000

       

      Formula Rules:

      1. If the numerator is greater than zero, but the denominator is zero, then the Sales rate is set to 1,000,000.
      2. If the numerator and denominator are both zero, then the Sales rate is zero.
      3. If the denominator is negative and the numerator is 0, then the Sales rate is set to 0.
      4. If the denominator is negative and the numerator is greater than zero, then the Sales rate is set to 1,000,000.

       

      What would the qlikview logic followed with the above rules