6 Replies Latest reply: Jul 29, 2011 7:54 PM by Vagos Pertsinis RSS

    Count presence of an item in the next 4 months

      Hello all,

       

      I'm trying to make a gauge in my application which will count how many application forms end in the next 4 months. Each application form has an end end, so technically i want to count how many dates appear from the current date up to 4 months in the future. As I'm new in Qlikview I find it a bit hard to write the right expression. At the moment I have:

       

      Count({Period={ '>=$(Date=Addmonths(Max(Date#(Period,'YYYYMM')), +4), 'YYYYMM'))' }>}[Appl End Date])

       

      which counts (something), but with not the right results.

       

      Thanks in advance for your help.