Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
antupe
Contributor III
Contributor III

Canonical Date-2 date fields from the same table

I have read several posts about canonical date, but I am still not getting it right. I have two different date fields (FechaEntradaTODO and HoraAceptadoTODO) within the same table and I need a canonical date in order to represent these in the same graph.

This is my script:

antupe_0-1652788270855.png

For most of the dates it is working correctly but for some reason some are not working, like the following, where two dates that have nothing to do with one another  appear as CanonicalDate:

antupe_1-1652788473187.png

Any idea  of why this is happening, maybe I am not mapping correctly? Or could it be because both variables come from the same table?

 

Labels (1)
  • Other

0 Replies