7 Replies Latest reply: Nov 29, 2012 8:01 AM by sandston RSS

    Counting in Qlikview

      I am querying two issues:

       

      1) Is it possible to have a list of dates formatted as :

               

                     01/01/2012

                     02/01/2012

                     03/01/2012

                     04/01/2012

                     05/01/2012

                     06/01/2012

       

      All the way up to the current date today 23/11/2012, to seperate the dates by Month? so maybe have it formatted to look like

               

           January +

           February +

           March +

           April +

       

      This would then expand to list the dates within January etc.

       

      2) With this list date I would be able to write an if statement which looks at the the day to calculate the total number of instances on that given day? and then do the same for the month field?