3 Replies Latest reply: Oct 3, 2011 6:42 AM by mshrimpton RSS

    Help on a Expression Definition

      Hi All

       

      Im fairly new to Qlikview and needed some help on the syntax for the following expression definition.

      This is what I am trying to achive:

       

      Sum of

      Amountfield

      Divided by

      Number of days between Datefield1 & Datefield2

      Multiplied by

      Number of days between Datefield1 and the current system date.

       

      AmountField / (DateField1 - Datefield2) x (Datefield1 - systemdate)

       

      Any advise would great!

       

      Thanks