1 Reply Latest reply: Apr 28, 2016 12:37 PM by Sunny Talwar RSS

    ¿How to create default calendar in QlikSense?

    Sebastián Garcíá

      Hi there,

       

      I need to cout values in different dimensions using the default calendar to can use 2 different fields (Excel).

       

      For example:

       

      I have 2 fields:

       

      START DATE     FINISHED DATE,

       

      XXXXX               XXXX   

      XXXXX              

       

      I have to plot the count of start date and count of finished date. The problem is, when i count the finished date and this date is above of today date, does not count!

       

      My current linechart is the following:

       

      qlik.jpg

       

      The final table should be like:

       

      START DATE     FINISHED DATE,   [TEMPORAL DATE}

       

      XXXXX               XXXX                        XXXXX

      XXXXX                                                XXXXX

                                                                 XXXXX

                                                                 XXXXX

       

      and i count only the values in START DATE and FINISHED DATE with TEMPORAL DATE as dimension.

       

      Thanks in advance.

       

      Best regards.