Not connecting date in simple table - why

[renovero]

Hello.
I have added an xls example from my case.

I'm wondering why, when I load the data to Qlik the "Data" column is not connected together.
In this case, when I add full table and then add multi-box with "Data" - i have two separate data chooses, even if, the data in this chooses is the same.



I assume that "Data" column is connected somehow with "Godzina" column, and because of that - it separates that field.

How could I avoid that? How could I sum all identical data to one record?

[tresesco · Accepted solution]

This could be because your date values have timestamp at the backend that are different from each other. You can try to load the date like:

Load
     Date(Floor(Data)) as Data

[renovero]

It was that, when I load data as you described.
Super fast response, thank you for your help 🙂