topic Re: Not connecting date in simple table - why in QlikView

Not connecting date in simple table - why

renovero — Sat, 16 Nov 2024 04:09:35 GMT

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?

Re: Not connecting date in simple table - why

tresB — Fri, 15 Mar 2019 09:03:57 GMT

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

Re: Not connecting date in simple table - why

renovero — Fri, 15 Mar 2019 09:13:10 GMT

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