Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

Labels (1)
1 Reply
sunny_talwar

See if this link is helpful: Canonical Date