Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

¿How to create default calendar in QlikSense?

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.

1 Reply

Re: ¿How to create default calendar in QlikSense?

See if this link is helpful: Canonical Date

Community Browser