Monday, May 21, 2012
Register

You are here  >  Forums  >  QlikView  >  Desktop  >  Less than in the Set Analysis statement





Less than in the Set Analysis statement
Last Post 16 Apr 2010 12:45 PM by QlikConnect. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Informative
QlikConnect
New Member
New Member
Send Private Message
Posts:50
QlikConnect

--
16 Apr 2010 12:45 PM
    Recently we had to include a less than statement in a set analysis formula. After some trial and error (and after the help of a colleague) we were able to construct the following statement.

     Sum ({$<Year = {$ (vYearCurrent) }, Period = {"<=$(#=$(vPeriodeCurrent) - 1)"}, &amp;#91;Account type&amp;#93; = {'S'} >} [Saldo Actual]) <year (vyearcurrent)="" period="{"&lt;=$(#=$(vPeriodeCurrent)" -="" 1)="" },="" [account="" type]="{'S'}">


    I hope this helps for anyone who has to overcome the same challenge.
    Kind regards,
    The QlikConnect Team

    QlikConnect.com, an independant community for QlikView enthusiasts.
    You are not authorized to post a reply.

    Forums > QlikView > Desktop