¿How to create default calendar in QlikSense?

[#1]

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:

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.

[sunny_talwar]

See if this link is helpful: Canonical Date‌