4 Replies Latest reply: Jan 22, 2014 11:15 AM by Alex Carlon RSS

    Set Analysis Date Range

    Daniel Liebenberg

      Hi Qlikview Community,

       

      I really hope that you could assist me with the following.

       

      I'm having some trouble creating a set analysis that will calculate the amount paid during a certain period of time per client. I have 2 date fields which I imported from an Excel file. The two date fields (per client) are as follow:

       

      * DateField_1 = Start date of membership

      * DateField_2 = End date of membership

       

      I require the set analysis to calculate the sum total of amounts paid between the two mentioned date. A normal Excel if statement should look something like this:

       

      if(DateField_1 <= DateField_2, sum(AMT_Paid), 0)

       

      Please help! I've read many posts, but am a bit confused with regards to the use of the " " and ' '. Also not sure when to use it.

       

      Cheers,

       

      Niel